Datastage Parameter value change inside the transformer

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
Md Dawar Mughni
Participant
Posts: 10
Joined: Wed Sep 30, 2009 11:55 pm
Location: Pune,India
Contact:

Datastage Parameter value change inside the transformer

Post by Md Dawar Mughni »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

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.
manoj_23sakthi
Participant
Posts: 47
Joined: Tue Feb 23, 2010 12:16 am
Location: CHENNAI

Post by manoj_23sakthi »

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
manoj_23sakthi
Participant
Posts: 47
Joined: Tue Feb 23, 2010 12:16 am
Location: CHENNAI

Post by manoj_23sakthi »

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
Md Dawar Mughni
Participant
Posts: 10
Joined: Wed Sep 30, 2009 11:55 pm
Location: Pune,India
Contact:

Post by Md Dawar Mughni »

Thnaks Ray.
This is my first post so made the mistake.

I have raise it in Enterprise Edition forum.

Please answer.

Regards
Dawar
Md Dawar Mughni
Participant
Posts: 10
Joined: Wed Sep 30, 2009 11:55 pm
Location: Pune,India
Contact:

Post by Md Dawar Mughni »

Thanks for the answer,
Could you please explain the logic.
Thnaks
-Dawar
manoj_23sakthi wrote:Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
Post Reply