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
- 26228 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
During the running session, output files are created by informatica server. Enlist few of them.
What is an expression transformation?
Write the prerequisite tasks to achieve the session partition?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Differentiate between reusable transformation and mapplet.
Mention few power centre client applications with their basic purpose?
Explain pushdown optimization and types in informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the designer tools for creating transformations?
write a query to retrieve the latest records from the table sorted by version(scd)
What is intricate mapping?
How to Create a folder using pmrep command?
differences between service based and product based?
what is size of u r database?
What is sequence generator transformation in informatica?
