take one sequence generator and poppulate the sequence nos to all rows th

i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Question Posted / jacob

Answer Posted / jacob

take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain what are the different types of transformation available in informatica.

1119

What is the difference between a connected look up and unconnected lookup?

953

Clarify the aggregator change?

1013

what is the complex transformation you used in informatica

2579

Explain about Informatica server process that how it works relates to mapping variables?

1048

How do you load unique records into one target table and duplicate records into a different target table?

1205

How do you change a non-reusable transformation to reusable transformation?

986

What is the difference between source qualifier transformations source filter to filter transformation?

1033

What is an expression transformation in informatica?

1008

COM components can be used in Informatica

2368

What does cheating measurement mean?

1032

What is the reusable transformation?

1035

What is the meaning of decode in informatica?

1108

Explain the pipeline partition with real time example?

1123

Why update strategy and union transformations are active? Explain with examples.

1219