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?
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Explain the ChangeApply stage?
What are the different common services in datastage?
how can u find out the datastage job is running on how many nodes
What is the process of killing a job in datastage?
how to sort two columns in single job in datastage.
What is aggtorec restructure operator?
Can you explain engine tier in information server?
What are the job parameters?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
What are the types of views in datastage director?