sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answer Posted / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
What is update strategy transform?
difference between repository database and repository service?
What are roles and groups and benefits of using them?
Explain the features of connected and unconnected lookup.
How many dimensions are there in informatica?
What is the session task and command task?
What are the designer tools for creating transformations?
What are the prerequisite tasks to achieve the session partition?
Differentiate between a database and data warehouse?
how to load rows into fact table in data warehouse
What is the use of target designer?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the new features of informatica 9.x developer?
Explain why we use partitioning the session in informatica?