table a contains 5 columns and table b contains 5 columns how can i get 10 colu

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?

Question Posted / oct10

9 Answers
15114 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / ramachandra rao.pinninty

In both tables having any common key column use join
stage,other wise in both the tables any columns having same
data type and data length use lookup otherwise that means
there is no common key column,and data length,types are not
same using surrogate key or column generator in both the
tables use join stage.in target it dispaly's 10 fields.

NOTE:the question was little bit clumbsy(there is no clarity)
so these are the way's to solve the senario.

Is This Answer Correct ?

5 Yes

0 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / venky

u can generate sequece generator for both the tables and u
can use joiner transforation,u can get 10 columns

Is This Answer Correct ?

3 Yes

0 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / srinivas

u can generate surrogate key generator for both the tables
and u can use Inner join based on key column i.e surrogate
key and u can get 10 columns..

Is This Answer Correct ?

5 Yes

3 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / rajesh.dwh

To do this in server job: use merge stage/transformer stage
to join these two tables (Ta and Tb) mapping them and load
it into target (sequential/ODBC/ORACLE) etc.

To do this in parallel job: use merge/joiner stage and do
above task.

thanks & regards:
todbarajesh@gmail.com

Is This Answer Correct ?

2 Yes

4 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / akhi

It is Simple in join stage fullouterjoin technique we get
all 10 coloumns

Is This Answer Correct ?

1 Yes

3 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / naresh

IF the metadata is same then we can do this by using funnel
stage.
If the metadata is dirrerent then we can do this by using
join,lookup,merge stages

Is This Answer Correct ?

3 Yes

8 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / arshad basha

hi... if the meta data are same in both tables we can go for funnel stage.If atleast one column is same in both tables we can go for merge and join stage and ofcourse can use look up.

Is This Answer Correct ?

2 Yes

8 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / vinay kumar

IF THE TABLE A HAVING STRUCTURE,TABLE B HAVING SAME
STRUCTURE LIKE TABLE A WE CAN GO THROUGH AS FUNNEL STAGE.

Is This Answer Correct ?

1 Yes

10 No

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target? ..

Answer / vijendra

copy stage also working

Is This Answer Correct ?

0 Yes

13 No

Post New Answer