how can we extract data with out having any common column
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 |
Post New Answer View All Answers
Highlight the main features of datastage?
What are some different alternative commands associated with "dsjob"?
what are the errors,warnings in datastage
in oracle target stage when we use load option and when we use upsert option?
What are the primary usages of datastage tool?
table actions available in oracle connector?
What are the types of containers?
What are the components of datastage?
What are the difference types of stages?
Describe stream connector?
Differentiate between datastage and datastage tx?
Define ds designer?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is active and passive stage?
How to perform incremental load in datastage?