3 Replies Latest reply on Feb 17, 2013 3:18 AM by SachinAhuja

    SQLLOADER When Clause


      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.

      Sachin Ahuja