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
- 32863 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
Define orabulk and bcp stages?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Name the third party tools that can be used in datastage?
Nls stands for what in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are orabulk and bcp stages?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are constraints and derivations?
What is a merge in datastage?
What is the flow of loading data into fact & dimensional tables?
what is the difference between == and eq in UNIX shell scripting?
I have a few records just I want to store data in to targets cycling way how?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the some differences between 7.x and 8.x version of datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
