Skip to Main Content

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!

How to filter records of specific length from a Fixed Width flat file in ODI?

2628428Mar 28 2014 — edited Apr 2 2014

Hi Experts,

I am reading a fixed width flat file of 200 characters. The requirement is that if there are any records

of less than 200 -> reject it and load it in error file

of more than 200 -> reject it and  load it in error file

equal to 200  -> let it load to the target table.

Is there any way we can achieve it in ODI tool? Any quick help is highly appreciated!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2014
Added on Mar 28 2014
5 comments
2,481 views