Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 26237 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / kamlesh mishra
The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip header
rows in the file.
And for last rows implement following logic.
1) Take sorter transformation reverse the rows on the basis of some key field like empno.
2)take expr transformation add nextval from sequence generator
3) Take filter transformation add condition nextval !=1 .
4)(optional)reverse the rows again using sorter transformation.
5) From filter to tgt connect the respective ports.
Src---->SQ--->SORTER--->EXPR---->FILTER---->SORTER---->TGT
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Why filter transformation is an active one?
What are the differences between a connected lookup and unconnected lookup?
What is primary and backup node?
Is it possible to define a single node as a Gateway node as well as worker node?
How to improve the performance of a session using sorter transformation?
What is session task and command task?
What are pre and post-session shell commands?
Can we create two repositories on same database instance in oracle?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the components of workflow manager?
How does the aggregator transformation handle null values?
What is rank index in rank transformation?
How many ways are there to do 'remove duplicate records in informatica'?
