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
- 11091 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
which r the connectors used in san?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How a routine is called in datastage job?
How you can fix the truncated data error in datastage?
What is the difference between server job and parallel jobs?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the purpose of pivot stage?
Differentiate between validated and Compiled in the Datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What a datastage macro?
In Datastage, how you can fix the truncated data error?
What are the different plug-ins stages used in your projects?
How many Key we can define in remove duplicate stage?
options available in sequence job to run,validate?
What is the difference between an operational datastage and a data warehouse?
