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
- 11325 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 difference between server job and parallel jobs?
What is a quality stage in datastage tool?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is size of a transaction and an array means in a datastage?
What are the steps required to kill the job in Datastage?
How can you write parallel routines in datastage PX?
Define project in datastage?
Describe stream connector?
What is apt_config in datastage?
Define Data Stage?
What are the some differences between 7.x and 8.x version of datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
AGGREGATOR default datatype
Name the command line functions to import and export the DS jobs?
