create a one dummy column in both tables . like dummy x in t1 table,

how can we extract data with out having any common column

Question Posted / vijay

Answer Posted / vijay

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between orabulk and bcp stages?

1073

how to sort two columns in single job in datastage.

2957

How to find value from a column in a dataset?

2250

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330

why do u need the IOS upgradation in a FC switch

2337

In Datastage, how you can fix the truncated data error?

1201

What are the stages in datastage?

1137

If you want to use the same piece of code in different jobs, how will you achieve it?

1218

Differentiate between odbc and drs stage?

1103

Explain usage analysis in datastage?

1224

What is the difference between in process and inter process?

1203

What are the various kinds of the hash file?

1196

Why do we use link partitioner and link collector in datastage?

1187

Explain the importance of surrogate key in data warehousing?

1233

Triggers,VIEW,Procedures

1266