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
- 30986 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
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to add a new records into source?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Define ds designer?
If you want to use the same piece of code in different jobs, how will you achieve it?
in oracle target stage when we use load option and when we use upsert option?
How many types of sorting methods are available in datastage?
What is use Array size in datastage
What is ibm datastage?
What steps should be taken to improve Datastage jobs?
What a datastage macro?
Have you have ever worked in unix environment and why it is useful in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How do you import and export data into datastage?
What is the flow of loading data into fact & dimensional tables?
