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
- 11326 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
What is the purpose of pivot stage and types of containers in datastage
Explain ibm infosphere information server and highlight its main features?
Where do the datastage jobs get stored?
How many types of stage?
what is ds administrator used for?
How many types of sorting methods are available in datastage?
Demonstrate experience in maintaining quality process standards?
explain about citrix scheduling tool in datastage
Is the value of staging variable stored temporarily or permanently?
How to convert RGB Value to Hexadecimal values in datastage?
Triggers,VIEW,Procedures
Name the different types of Lookups in Datastage?
what are the errors,warnings in datastage
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
