How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 24207 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / maneesh
To eliminate first row, simply use a counter in Expression and then Filter.
To eliminate the last row, make two pipelines with the same source
In first pipeline, use AGGREGATOR without any Group By ports In second pipeline, join it with the above with JOINER. Use and Outer Join and then other than that Joined row .. load all the rows.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
Explain sql transformation in script mode examples in informatica
How to use procedural logic inside infromatica?
Design a mapping to load a target table with the following values from the above source?
What is the surrogate key?
What is dynamic cache?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the components of workflow manager?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the various types of transformation?
How do you load only null records into target?
What are junk dimensions?
COM components can be used in Informatica
What is the difference between a repository server and a powerhouse?
What is the difference between stop and abort in informatica
