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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is ds administrator used for?
Why do you need stage variables?
What are stage variables?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are sequencers?
What are system variables and sequencers in datastage
EXPLAIN SCD
Enlist various types of routines in datastage.
What are the types of jobs we have in datastage?
What is the difference between datastage and informatica?
what are the errors,warnings in datastage
How do you remove duplicate values in datastage?
what is the use of materialized view?
Can you explain tagbatch restructure operator?