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
- 10118 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumar
As you have a single text file as Source. Use folloowing
approach to get the desired output.
Head1 Target1
Seq. File Copy Tail2 Target2
Head3 Tail Target3
Steps:
1.> Read your source file using sequential file stage.
2.> Pass the records to copy stage and take 3 output link.
3.> 1 to Head stage head1, 2nd to Head2 and 3rd to Head3.
4.> In the 1st Head Stage Head1, in the properties specify
1, it will pick up the 1st record and make that record to
target 1.
5.> Similarly, to capture last record in target2, in Tail
stage property mention 1. It will take last record and pass
it to target2.
6.> To load rest records 1st using head stage, capture top
records say, if u have 10 records in the source pick top 9
records using head stage then use tail stage followed by
head stage and mention 8, it will pick all records except
1st one. then u can load these to target3.
If u get confused ask me ....
Thanks
Kumar
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
sed,awk,head
Could anyone give brief explanation bout datastage admin
How do you remove duplicate values in datastage?
What is a merge?
How to read the length of word in unix?
What is aggtorec restructure operator?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the difference between operational data stage (ods) and data warehouse?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What all are the different way to run a job?
In Datastage, how you can fix the truncated data error?
What is difference between server jobs & parallel jobs?
How can one find bugs in job sequence?
What is the difference between the local container and shared container?
Can you explain engine tier in information server?
