Concatenation of two tables without having common column
how it can be done on data stage PX 7.5
Concatenation of two tables without having common column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Fri Oct 05, 2007 8:42 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. If you Search the forum you will find that this has been answered before.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Concatenation of two tables without having common column
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
SRINIVAS
Re: Concatenation of two tables without having common column
Hi,
Use modify stage to change the column name.
Sura
Use modify stage to change the column name.
Sura
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Re: Concatenation of two tables without having common column
Hey !there is no need. Use the dummy column having same value as sri.cbv has posted.SURA wrote:Hi,
Use modify stage to change the column name.
Sura
Code: Select all
Hi
generate a common column using column generator.
Thanx