IF the metadata is same then we can do this by using funnel stage. If the

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

Question Posted / naresh

9 Answers
15189 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

804

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2205

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

777

What is ds designer?

1098

What is difference between server jobs & parallel jobs?

1036

describe the Steps to confiure a Qlogic switch

2383

How a server job can be converted to a parallel job?

1093

Explain entity, attribute and relationship in datastage?

1092

How to perform incremental load in datastage?

1198

What all are the different way to run a job?

1090

What are iconv and oconv?

1240

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408

Is it possible to query a hash file?

2007

What are the processing stages?

1099

Is possible to create skid in dim,fact tables?

2635