Concatenation of two tables without having common column

Soumya Pradhan · Post by **Soumya Pradhan** » 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

ray.wurlod · Post by **ray.wurlod** » Sat Oct 06, 2007 7:52 am

Welcome aboard. If you Search the forum you will find that this has been answered before.

sri.cbv · Post by **sri.cbv** » Fri Feb 29, 2008 12:41 am

Soumya Pradhan wrote:Concatenation of two tables without having common column
how it can be done on data stage PX 7.5

Hi

generate a common column using column generator.

Thanx

SURA · Post by **SURA** » Fri Feb 29, 2008 12:49 am

Hi,

Use modify stage to change the column name.

Sura

AmeyJoshi14 · Post by **AmeyJoshi14** » Fri Feb 29, 2008 2:23 am

SURA wrote:Hi,

Use modify stage to change the column name.

Sura

Hey !there is no need.

Use the dummy column having same value as sri.cbv has posted.

Hi 

generate a common column using column generator. 

Thanx

DSXchange