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 / srinivas bolusupati
Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
What is a filter transformation?
How to do unit testing in informatica? How to load data in informatica ?
What are the uses of etl tools?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How would you join a node to the already existing domain?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How many dimensions are there in informatica?
What is the need for an etl tool?
What is a snowflake schema?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between source qualifier transformations source filter to filter transformation?
How many numbers of sessions can one group in batches?
What is rank transformation?
Performance tuning( what you did in performance tuning)