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?
- 2 Answers
- 11087 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is the differentiate between data file and descriptor file?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Why fact table is in normal form?
What is "fatal error/rdbms code 3996" error?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the important features of datastage?
State the difference between an operational datastage and a data warehouse?
What is the purpose of pivot stage?
Difference between server jobs & parallel jobs?
What are stage variables and constants?
Does datastage support slowly changing dimensions ?
What are the benefits of datastage?
What are the types of views in datastage director?
Difference between sequential file and data set?
Give an idea of system variables.
