Informatica: How do u get the first record from 50,000 records?

Question

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Answer 1

Hi,

To achieve this output there are many ways:

1) Src --> SQ --> Seq --> Exp --> Fil --> Tgt

So in your Expression Transformation via Sequence Generator your records would get numbered.
And, in your filter you can give condition as NEXTVAL=1, and there is your output.

2) You can write a Query in your SQ Transformation itself.
SELECT * FROM TABLE_NAME WHERE PK=1;
Note: Please specify all the columns in place of *

3) Src --> SQ --> Rnk --> Tgt
Under Properties Tab, Select Top 1.

4) Src --> SQ --> Seq --> Agg --> Tgt
User FIRST function in Agg Trnfn for all Columns

Hope this helps you...If you find my answers useful VOTE on me.

thanks

Arif