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

Facebook Login
Site Registration

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

+2 votes
421 views
How to load only the first and last record of a flat file into the target?
posted Jun 25, 2015 by Sachin

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

1 Answer

0 votes

we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session shell commands in session

or-

using Aggregator trans FIRST and LAST funtions we can pass first and last record

answer Jul 6, 2015 by Manikandan J
Similar Questions
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?

+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?

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
...