Answered Questions

  • Nov 12 2008
    05:39 PM
    27060
    33

    Load only the First and Last Record

    • thallojur

    How to load only the first and last record of a flat file into the target?

    kishor Baindoor

    • Jan 23rd, 2016

    Connect source to two aggregator and then union it. In aggregator, if we donot check any column for aggregation then it will return last record by default. We can change this property in 2nd aggregator to return first record. When we union it we will get first and last record.

    Raghav

    • Apr 4th, 2015

    Using rank and expression transformation.
    More details at below link
    http://www.raghavatal.com/2015/04/04/how-to-load-only-the-first-and-last-row-from-a-flat-file-to-a-target-file/