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
- 28783 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 the purpose of pivot stage?
What is datastage engine?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Explain usage analysis in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is repositery?
What is the precedence of stage variables,derivations, and constraints?
Define oconv () and iconv () functions in datastage?
Define Data Stage?
Triggers,VIEW,Procedures
What are some different alternative commands associated with "dsjob"?
What is the difference between datastage and datastage tx?
Can you implement SCD2 using join, transformer and funnel stage?
how can we create rank using datastage?what is the meaning of rank?
