Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I am Vijay
In my source i've 10 records in a single column.... but i
want to split those records into 5 sequential files each
seq file contains 2 records.?.... can any body help me?
- 15 Answers
- 33589 Views
- Scope International, I also Faced
- E-Mail Answers
Answer Posted / dileep
Hi This is Dileep,
Take one Sequential File, One Copy Stage and Put 5 O/P Links to Sequential Files.
From Sequential File, Map Directly to Copy Stage and to Sequential Stage.
In the target Sequential File, In the "Options", One 'Filter' Option is there. In that... Put the Condition like the below..
1 O/P---- head -2
2 O/P---- head -4| tail -2
3 O/P---- head -6| tail -2
4 O/P---- head -8| tail -2
5 O/P---- tail -2.
Similarly U can achieve this in Datastage by Using the Debug Stages 'Head' and 'Tail'. Precondition is to Run the Job on 'Single Node' or 'Sequentially'.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What all the types of jobs you developed?
what is the use of skid in reporting?
Describe the architecture of datastage?
Can you explain players in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
To see hidden files in LINIX?
Where the datastage stored his repository?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the different types of lookups in datastage?
What is use Array size in datastage
Difference between in process and inter process?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the precedence of stage variables,derivations, and constraints?
How a routine is called in datastage job?
How you can fix the truncated data error in datastage?
