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
- 30716 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
How to convert RGB Value to Hexadecimal values in datastage?
How do u convert the columns to rows in datastage?
What is ibm datastage?
Difference between server jobs & parallel jobs?
How do you remove duplicate values in datastage?
What are the job parameters?
how to write server Routine coding?
What is aggtorec restructure operator?
What is the difference between Datastage 7.5 and 7.0?
State the difference between an operational datastage and a data warehouse?
How to manage date conversion 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 datastage engine?
What is the difference between hashfile and sequential file?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
