Skip to Main Content

Analytics Software

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
1,697 views