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?
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 is the command line function to import and export the ds jobs?
How to manage date conversion in Datastage?
What are sequencers?
What are the various kinds of containers available in datastage?
whom do you report?
How many types of sorting methods are available in datastage?
Name the different types of Lookups in Datastage?
What is the difference between hashfile and sequential file?
what is flow of project?
What are the processing stages?
What are the areas of application?
what is use of SDR function?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to RD using transformer?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?