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/

Answer Question  Select Best Answer

How to calculate max value of a column without using aggregrator transformation?

dihydrox

 Profile Answers by dihydrox Questions by dihydrox

• Dec 6th, 2008

If you just need to get the max value by the end of session (to increment a value or put at the bottom of a flat file ) you can do the following.  Let's say you need to find the max value f...

jryan999

 Profile Answers by jryan999 Questions by jryan999

• Sep 1st, 2008

You need to feed your ports through an Aggregator Tranformation.  eg.Input  = salary.  Not outputOutput = maximum_salary --> max(salary) - OutputConnect the maximum_salary fields to ...

Answer Question  Select Best Answer