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
- 26174 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
Explain sessions?
What is the status code in stored procedure transformation?
What is incremental aggregation?
is it possible to index the data in cache of lkp transformation ?
Explain about cumulative Sum or moving sum?
Differentiate between reusable transformation and mapplet.
What is the difference between source qualifier transformations source filter to filter transformation?
Briefly define reusable transformation?
How many types of sessions are there in informatica.please explain them?
explain about unit testing? in real time?
What is the way to execute pl/sql script using informatica mapping?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Which version configuration tool used in ur project?
what is song in infrmatica...?
How to load data in informatica ?
