I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
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 is the difference between Datastage 7.5 and 7.0?
What is data partitioning?
Describe stream connector?
What are the different kinds of views available in a datastage director?
What are the partitioning techniques available in link partitioner?
What is the method of removing duplicates, without the remove duplicate stage?
what is the use of skid in reporting?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How do u convert the columns to rows in datastage?
What is merge stage?
Differentiate between Join, Merge and Lookup stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
root tree will find which is server job and which is parallel job?
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
I have a few records just I want to store data in to targets cycling way how?