Datastage Parameter value change inside the transformer
Posted: Sun Jan 09, 2011 6:24 pm
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
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