u can generate surrogate key generator for both the tables and u can use I

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

Question Posted / srinivas

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

Please Help Members By Posting Answers For Below Questions

Which warehouse using in your datawarehouse

2233

Define Job control?

1225

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2490

What is ds designer?

1161

What is the purpose of pivot stage?

1231

Demonstrate experience in maintaining quality process standards?

2635

Differentiate between datastage and datastage tx?

1111

Explain how a source file is populated?

1416

How many types of stage?

1227

What are the steps required to kill the job in Datastage?

1265

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1558

What is the difference between operational data stage (ods) and data warehouse?

1292

Name the different types of Lookups in Datastage?

1313

How can we improve the performance in datastage?

1145

How to Remove Duplicate using SQL?

1422