Merge files

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nair
Participant
Posts: 11
Joined: Fri Oct 14, 2005 12:44 pm

Merge files

Post by nair »

Hello Everybody,
I want to know how merge stage works.
I know that we can merge columns from different sources.

Do Merge key need to have same metadata?
1) same column name
2) same type
and same length.


Thanks in Advance
Nair
vcannadevula
Charter Member
Charter Member
Posts: 143
Joined: Thu Nov 04, 2004 6:53 am

Re: Merge files

Post by vcannadevula »

nair wrote:Hello Everybody,
I want to know how merge stage works.
I know that we can merge columns from different sources.

Do Merge key need to have same metadata?
1) same column name
2) same type
and same length.


Thanks in Advance
Nair

Both the column name and the data type should be the same. If you have the column name as different use the modify stage to rename it.
arvind
Participant
Posts: 17
Joined: Sun Aug 07, 2005 7:57 am

Merge keys length lan be different

Post by arvind »

Hi Nair,
Merge KeyCoulmn Name and Type should be same.
Lenth may be differ.

If I'm wrong, Some body Please correct me.

Thanks in Advance
Arvind
Post Reply