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
Define APT_CONFIG in Datastage?
Does datastage support slowly changing dimensions ?
How many areas for files does datastage have?
Where the datastage stored his repository?
How to read the length of word in unix?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Give an idea of system variables.
What is the difference between odbc and drs stage?
On which Dimension Table you implemented SCD Type in your Project
What is the use of datastage designer?
What is the process of killing a job in datastage?
What are the different layers in the information server architecture?
Explain usage analysis in datastage?
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
Define project in datastage?