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 you can fix the truncated data error in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the different type of jobs in datastage?
what is the difference between == and eq in UNIX shell scripting?
What is the precedence of stage variables,derivations, and constraints?
explain about citrix scheduling tool in datastage
What is the flow of loading data into fact & dimensional tables?
how many rows sorted in sort stage by default in server jobs
Enlist various types of routines in datastage.
how to delete one row in target dataset
What is difference between join, merge and lookup stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Whats difference betweeen operational data stage (ods) and data warehouse?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Is the value of staging variable stored temporarily or permanently?