Sunday, June 12, 2011

I want to skip first 5 rows to load into target ?



> If your Source is a Flatfile and if you need to skip first 5 rows ...simply while Importing flatfile definition,
   set the properties as..Start import rows at option=6 .. generally 1 row goes as field names..so
   Start Import Rows at : 6

>  If  your source is a RDBMS, Override default SQL query as..

  SELECT * FROM EMP
  MINUS
  SELECT * FROM EMP WHERE rownum <=5

  so that records from 6 to n will be extracted by SQ..


> Other way..
   get the seq numbers using Seq-Gen-Tr.
   and in the Filter trasformation put condition as : seq_num > 5 .
   so only records from 5 - n records will be loaded into the target.

 

3 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete
  2. Thanks for providing the best information it's very useful for INFORMATICA learners.we also provide the best INFORMATICA Online Training
    .

    ReplyDelete
  3. learn Informatica Online Training By ReaTime IT Expert.Informatica Training .learn Informatica ETL By QEdge Technolgoeis IT Industry Expert Trainer

    ReplyDelete