2. Design a mapping to load the first 3 rows from a flat file into a target?
Solution:
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
This article is very nice and informative to learners
ReplyDeleteInformatica training, informatica training in bangalore, informatica online training
Informatica training, informatica training in bangalore, informatica online training