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
- 26216 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
What is standalone command task?
Clarify the utilization of aggregator cache record?
What is the benefit of partitioning a session?
What are the transformations that are not supported in mapplet?
How do you load only null records into target? Explain through mapping flow.
Can we get 1st record through Informatica(without sequence number).
What is the difference between informatics 7x and 8x and what is latest version?
What is a joiner transformation?
What are the prerequisite tasks to achieve the session partition?
Explain the mapping variable usage example in informatica
What is meant by LDAP users?
How are indexes created after completing the load process?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a dimensional model?
Can you generate sequence numbers without using the sequence generator transformation?
