i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / rakesh
use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How many dimensions are there in informatica?
Tell me about MD5 functions in informatica
State the limitations where we cannot use joiner in the mapping pipeline?
What is the difference between Active and Passive transformation?
What is meant by query override?
What is the format of informatica objects in a repository?
According to his methodology what all you need before you build a datawarehouse
What is the meaning of up gradation of repository?
What is rank transform?
Write the prerequisite tasks to achieve the session partition?
What are the performance considerations when working with aggregator transformation?
Explain the different kinds of facts.
What are the components of workflow manager?