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

What are the informatica performance improvement tips

1090

Explain pushdown optimization and types in informatica

1074

Explain the difference between mapping parameter and mapping variable?

1033

What is the use of code page?

1085

I have a flat file, want to reverse the contents of the flat file

1124

What is primary and backup node?

1123

Write the prerequisite tasks to achieve the session partition?

1150

When do you use sql override in a lookup transformation?

1088

Global and Local shortcuts. Advantages.

2032

How to extract the informatica rejected data?

1217

What is a dimensional model?

977

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1698

Reusable transformation and shortcut differences

1838

Under which circumstances, informatica server creates reject files?

1085

What are the different lookup cache(s)?

1113