use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and

i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .

Question Posted / rakesh

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

Please Help Members By Posting Answers For Below Questions

design of staging area?

2030

What are the issues you have faced in your project? How did you overcome those issues?

2365

What is depict expression change?

1125

Explain Dataware house architecture .how data flow from intial to end?

2587

What are the types of schemas we have in data warehouse.

963

What are the different types of olap? Give an example?

1057

What is a sequence generator transformation?

1023

How to create the source and target database connections in server manager?

1090

Sequence generator, when you move from develoment to production how will you reset

2042

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3872

How to differentiate between the active and passive transformations?

1168

What is sq transformation?

1163

What is deployment group?

1218

Clarify the aggregator change?

1032

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

2237