Design mapping to load the first record from a flat file into Table A, the Last record from a flat file into Table B, and remaining record into Table C

Nagendra

• Nov 5th, 2015

Append Seq Gen after SQ, add sorter, make it desc based on Sequence generated and use a variable to make first row as 0 then by using router route SEQGEN = 1 to A (First Row), Variable =0 to B (Last Row) and rest to C

sum

• Oct 8th, 2015

Use aggregator to take count of rows; then again join this aggregator to source pipeline using dummy columns. Now add one sequence generator and add next_val as srnum from it to each source columns...

Answer Question  Select Best Answer