Limiting records from a transformation

How can we limit records from the result of the transformation, for example, I want the top five records only so in MySQL I will used LIMIT 5.
I am having trouble in what transformation will I use to limit the records?

Hi Fatima,

You can limit your resultant records of a transformation using a ‘Filter’ and ‘Sequence Generator’ object. I have a provided a screenshot, containing the steps on how you can achieve that.

Let me know if this works for you.

Regards,
Khizar