top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: How to design a mapping to load the first 3 rows from a flat file into a target?

+1 vote
1,034 views
Informatica: How to design a mapping to load the first 3 rows from a flat file into a target?
posted Mar 14, 2016 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You have to assign row numbers to each record. Generate the row numbers either using the expression transformation as mentioned above or use sequence generator transformation.Then pass the output to filter transformation and specify the filter condition as O_count <=3

answer Mar 15, 2016 by Manikandan J
Similar Questions
0 votes

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?

...