Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between physical length and length

Rajneesh S-OracleJul 22 2020 — edited Jul 22 2020

Hello All,

What is difference between physical length and length here?

A value for example 12345 in actual source file was showing as numeric type here, before I manualy changed to string.

Similarly type for createDate was numeric.

I understand this is due to internal conversion by ODI that a string value (12345) and string value for date (5-JUL-20 03.29.36.000000000 PM) appeared as numeric.

However I guess I should convert manually every thing to string (than leaving as numeric) like below, as any thing in flat file is string in true sense.

pastedImage_0.png

Thanks,

Rajneesh
This post has been answered by XavierGrosfils on Jul 22 2020
Jump to Answer
Comments
Post Details
Added on Jul 22 2020
#business-intelligence-applications, #data-integrator, #system-management-and-integration
2 comments
819 views