This discussion is archived
3 Replies Latest reply: Feb 16, 2013 7:18 PM by SachinAhuja RSS

SQLLOADER When Clause

SachinAhuja Newbie
Currently Being Moderated
All,

We are using sqlloader to load data from a flat file to single table. However based on 1st character of data in flat file, positions of columns gets differ. To handle this scenario we have used various WHEN Clause Option in Control file. However on using WHEN Clause option file is not getting uploaded sequentially. Based on WHEN Clause on CTL file it is reading whole file & dumping to the table, then it is reading next WHEN Clause Option from Control file & dumping another set of records & so on...

In this case we are loosing the sequence of file, any way I can populate original line number of the file to my table. If I can achieve that, then I can do order by & work further on this data.


Any suggestion/help.

Thanks
Sachin Ahuja

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points