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
- 30946 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
Where do the datastage jobs get stored?
What are the various kinds of containers available in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Describe link sort?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
whom do you report?
What is difference between server jobs & parallel jobs?
What is process model?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the types of containers in datastage?
What are the functionalities of link collector?
how to write server Routine coding?
What are the different type of jobs in datastage?
How we can covert server job to a parallel job?
Where do you see different stages in the designer?
