Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15508 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
What are orabulk and bcp stages?
How can we improve the performance in datastage?
Difference between sequential file and data set?
What are the features of datastage flow designer?
how to delete one row in target dataset
client know skid info?
What could be a data source system?
Demonstrate experience in maintaining quality process standards?
Can you explain link buffering?
What is the difference between in process and inter process?
What are the components of datastage?
What is the command line function to import and export the ds jobs?
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?
What is difference between symmetric multiprocessing and massive parallel processing?
If you want to use a same piece of code in different jobs, how will you achieve this?
