How to load only first row and last row into the target ?

Using Aggregator transformation we can load first and last records into the target.

From Source Qualifier transformation, create 2 separate pipelines,

1st pipeline: Aggregator transformation to generate the last row. If we do not use group by then the aggregator returns the last row.
2nd pipeline: Aggregator transformation with FIRST command to generate the first row.

Use Union transformation to merge these 2 rows and push them to target.

Tag: Informatica interview questions