how can we load first and last record from a flat file
source to target?
Answer Posted / hina
Below transformation would work: Add the Nextval port of the sequence generator to both the Rank Transformations. In rank transformation select Top and Bottom resp.
------ Rank Transformation (Top)----Tgt(Ins1)
|
SQ---Sequence Generator-----
|
-------Rank Transformation(Bottom)-Tgt(Ins2)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
What is an aggregator transformation?
what is SDLC way of code development?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the differences between source qualifier and joiner transformation?
What does command task mean?
What the difference is between a database, a data warehouse and a data mart?
What are the reusable transformations?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you handle two sessions in Informatica
How we can use union transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What does refresh system mean, and what are its distinctive choice?
What is confirmed fact in dataware housing?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?