Interested to Buy Any Domain ? << Click Here >> for more details...
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
- 6 Answers
- 31170 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shiv
Sreenu is also right, but we have another option as well.
Use head and tail stages in datastage like this:
Seq_File-->Tail_stage--->Head_Stage---->Dataset(Target)
in this way first u can exclude the first record using tail specify 999 record in tail stage, then u can exlclude last record by using head stage.(998 top records).
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Define data aggregation?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How a routine is called in datastage job?
Define Merge?
Have you used Unstructured data?
How to read multiple files using a single datastage job if files have the same metadata?
What is the project in datastage?
what is use of SDR function?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to convert RGB Value to Hexadecimal values in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is staging variable?
What are system variables and sequencers in datastage
what is ds administrator used for?
