Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Answer Posted / subhash

We can do in this way as well:

In the same job,
SeqFile--->Target1
SeqFile--->Target2
SeqFile--->Target3
for Target1,
add Filter condition in the SeqFile as below:
Head -1

for Target2,
add Filter condition in the SeqFile as below:
Tail -1

for Target3,
add Filter condition in the SeqFile as below:
sed '1,$ d'

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define APT_CONFIG in Datastage?

1062


Does datastage support slowly changing dimensions ?

1099


How many areas for files does datastage have?

1144


Where the datastage stored his repository?

1076


How to read the length of word in unix?

1369


Different ways a project can be moved to production ?...example ….export-import and Version control.

2433


Give an idea of system variables.

1012


What is the difference between odbc and drs stage?

1080


On which Dimension Table you implemented SCD Type in your Project

2017


What is the use of datastage designer?

1142


What is the process of killing a job in datastage?

1001


What are the different layers in the information server architecture?

1117


Explain usage analysis in datastage?

1150


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2234


Define project in datastage?

1085