I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
- 4 Answers
- 14212 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / shivam
For this we can use Head and tail stages from development
and debug stages. Suppose we have 10 records,And we are
asked to pick 2nd to 9th record in the output, then go for
the following:
Sequential file--->Head stage--->Tail stage---->Data set
In the Head stage properties mention the number of records
you want to extract 9 records, this way you will get 1st to
9th records(top 9) extracted. Now, in Tail stage properties
mention number of records to extract 8, this way you get
last 8 records out of top 9 i.e 2nd to 9th. Finally as an
output you will find records 1st and 10th dropped.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Terminate Activity
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Explain how a source file is populated?
what are the errors,warnings in datastage
why do u need the IOS upgradation in a FC switch
What is the roundrobin collector?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the functionalities of link collector?
What are transforms and what is the differenece between routines and transforms?
What is the purpose of pivot stage?
What is ibm datastage flow designer?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the purpose of interprocessor stage in server jobs?
what is use of SDR function?
