Concatenation of two tables without having common column
Posted: Sat Oct 06, 2007 6:22 am
Concatenation of two tables without having common column
how it can be done on data stage PX 7.5
how it can be done on data stage PX 7.5
DSXchange
A short text to describe your forum
http://dsxchange.com./
Concatenation of two tables without having common column
Page 1 of 1
Posted: Sat Oct 06, 2007 7:52 am
Welcome aboard. If you Search the forum you will find that this has been answered before.
Re: Concatenation of two tables without having common column
Posted: Fri Feb 29, 2008 12:41 am
HiSoumya Pradhan wrote:Concatenation of two tables without having common column
how it can be done on data stage PX 7.5
generate a common column using column generator.
Thanx
Re: Concatenation of two tables without having common column
Posted: Fri Feb 29, 2008 12:49 am
Hi,
Use modify stage to change the column name.
Sura
Use modify stage to change the column name.
Sura
Re: Concatenation of two tables without having common column
Posted: Fri Feb 29, 2008 2:23 am
Hey !there is no need.SURA wrote:Hi,
Use modify stage to change the column name.
Sura
Use the dummy column having same value as sri.cbv has posted.Code: Select all
Hi
generate a common column using column generator.
Thanx