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!

Change 50 chars field length default in file datastore

3673816Oct 22 2018 — edited Oct 23 2018

Hi Forum.

Is there any way to change the default 50 characters long field length default in a file type data store?

I have a large file (over 200 columns) and when I reverse-engineer it, all columns get created with the default 50 chars length. I have to manually go in and adjust every column to the actual length that I need.

Ideally, I would like ODI to read in all the rows from the file, figure out the longest values and make that the respective columns' lengths. I am not sure that's possible, though.

So, at the very least, I would like

This post has been answered by Adrian_Popescu-Oracle on Oct 23 2018

Jump to Answer

Added on Oct 22 2018

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

5 comments

1,260 views