prasoon.pandey

 Profile Answers by prasoon.pandey 

• Sep 18th, 2007

 

If suppose two stage don’t have the same column name then in between use one Transformer stage and map the required column.

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

 

Hi,

First of all tell me those are stages or sources.

If those are sources then u better use copy stage after one stage and change the column name according to ur requirement , then join these two sources.

If it is oracle database then select the user def sql, there u put alias name and change the col name by selecting the columns tab.

Amritendra kumar

 Profile Answers by Amritendra kumar 

• Feb 22nd, 2008

 

In both stage create one extra port and assign the value of those port is 0 then join it.
but best option is allready suggested that use Transformer stage and map required column.

kalyan

• Oct 10th, 2012

 

We can connect the two job activity stages without any column.

leha

• Dec 3rd, 2012

 

Use transformer or generate extra rows and using column generator and make same number of columns in 2 inputs and join.

muralidhar

• May 30th, 2013

 

This is little tricky question.we can do in two ways.

1)we can connect using lookup stage if both columns having same datatype.

2)We can add one extra column that is common for two files then we can connect.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

 

If those two stages are sources and if it is valid that though the names of columns from two sources differ but they are same, then use a copy stage infront of one source stage and rename column as per those in the second source.

If one of them is a database stage, then do the renaming inside the source stage itself.

If they both are files and there is not related but still you want them to be connected, then use a column generated next to each source and generate a column with name as DUMMY and value as 1 and then join them based on the DUMMY column.