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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the benefits of datastage?
what is use of SDR function?
Notification Activity
what is the use of surogate key in datastage
What are sequencers?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between the local container and shared container?
project Steps,hits, Project level HArd things,Solved methods?
Differentiate between datastage and informatica?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is a folder? Difference types of stages?
How one source columns or rows to be loaded in to two different tables?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this