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
design of staging area?
What are the issues you have faced in your project? How did you overcome those issues?
What is depict expression change?
Explain Dataware house architecture .how data flow from intial to end?
What are the types of schemas we have in data warehouse.
What are the different types of olap? Give an example?
What is a sequence generator transformation?
How to create the source and target database connections in server manager?
Sequence generator, when you move from develoment to production how will you reset
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to differentiate between the active and passive transformations?
What is sq transformation?
What is deployment group?
Clarify the aggregator change?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records