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
- 30929 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
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain Quality stage?
What are stage variables?
How to reverse the string using unix?
What is ds designer?
What is a datastage job?
How do you generate sequence number in datastage?
Why do you need stage variables?
what is the difference between == and eq in UNIX shell scripting?
What are orabulk and bcp stages?
How do you schedule or monitoring the job?
What is the difference between operational data stage (ods) and data warehouse?
What is active and passive stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is "fatal error/rdbms code 3996" error?
