Hi All,
The requirement is to split the file into multiple files based on
1.Each file should contain specific number of records or less then that
and
2.All the key columns should be in single file
Eg:
source file :
col1 col2
1 a
1 b
1 c
2 d
3 k
3 g
4 b
5 x
5 b
if number of records in each o/p file should be <= 4
then outpu files would be
file1:
col1 col2
1 a
1 b
1 c
2 d
file2:
col1 col2
3 k
3 g
4 b
file3:
col1 col2
5 x
5 b
How to impliment it in Datastage?
Appreciate the help in advance.
Warm Regards,
-Dawar
Datastage Parameter value change inside the transformer
-
- Participant
- Posts: 10
- Joined: Wed Sep 30, 2009 11:55 pm
- Location: Pune,India
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
This particular forum is for the Transformation Extender, not for DataStage. You should have posted your question in the Enterprise Edition forum.
This particular forum is for the Transformation Extender, not for DataStage. You should have posted your question in the Enterprise Edition forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
-
- Participant
- Posts: 10
- Joined: Wed Sep 30, 2009 11:55 pm
- Location: Pune,India
- Contact:
-
- Participant
- Posts: 10
- Joined: Wed Sep 30, 2009 11:55 pm
- Location: Pune,India
- Contact: