I am using ODI 12c so the mission is to insert one plat file into one table Oracle
the file is like :
H030201707761133020171085009CA0126357320150506141438SL xxxx xxx xxx
***DEB062
09001SD
1003020171085009
....
...
..
.
.
.
0000010000001389600000013896
509000002
199
***FIN062
I have one table 'A' which constitute one column 'COL' (lenght=250) where I want to save all my file's text (insert line by line). it save it but not like in my file order why !
it save it like
1003020171085009
xxxx
1003020171085009
....
...
..
***FIN062
.
H030201707761133020171085009CA0126357320150506141438SL xxxx xxx xxx
.
509000002
199
0000010000001389600000013896
We found a solution .If you are using ODI you need only put nothing in INSERT_HINT input text .let it empty like in picture below...And it will save your lines as they are in the plat file