top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

If we have 10 records in a file, can we get first record from it by using Aggregator with out using Group by Port in it?

0 votes
222 views
If we have 10 records in a file, can we get first record from it by using Aggregator with out using Group by Port in it?
posted Aug 14, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

If you do not select any group by port in an Aggregator transformation and also want the first record of any input record set, then, simply use the FIRST function with no group by ports selected. Because, if there is no group by ports selected, by default, FIRST treats all rows as one group, returning one value. However, make sure that the first record is not NULL. If a value is NULL, FIRST
ignores the row.

--Or--

Dont use group by.By default it will give last row.To override it,use FIRST function.

answer Aug 14, 2015 by Manikandan J
Similar Questions
+1 vote

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

0 votes

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...