Wednesday, December 5, 2012

2. Design a mapping to load the first 3 rows from a flat file into a target?

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

1 comment:

  1. This article is very nice and informative to learners

    Informatica training, informatica training in bangalore, informatica online training

    Informatica training, informatica training in bangalore, informatica online training

    ReplyDelete

Thank you :
- kareem