> 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.
Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
ReplyDeleteInformatica 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
Thanks for providing the best information it's very useful for INFORMATICA learners.we also provide the best INFORMATICA Online Training
ReplyDelete.
This comment has been removed by the author.
ReplyDelete