Read flat file with multiple columns

xch2005 · Post by **xch2005** » Tue May 31, 2011 2:54 pm

Hi,

I am trying to read a sequential file with multiple columns. The total number of columns depend on the value in first column. Then take the values from the columns and load it into Oracle tables.

Say, (as given below) if first column value is A1 there will be 5 columns or if it is A2 there always 3 columns

A1,c2,c3,c4,c5
A2,b2,b3

What would be the efficient way to read this file and load to a table

Appreciate your suggestions.

Thanks

arunkumarmm · Post by **arunkumarmm** » Tue May 31, 2011 3:35 pm

Read the entire record as one single column (With the length you think will be the maximum) and route it as required in a transformer with constrains A1/A2 etc., if thats all you need to do.

xch2005 · Post by **xch2005** » Wed Jun 08, 2011 2:33 pm

Thanks for the suggestion