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
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Difference between sequential file and data set?
What is meta stage?
Why do we use exception activity in Datastage?
What are data elements?
What is the difference between passive stage and active stage?
What are the different kinds of views available in a datastage director?
what is the difference between == and eq in UNIX shell scripting?
What are the different type of jobs in datastage?
What is a quality stage in datastage tool?
how to write server Routine coding?
What are the functionalities of link partitioner?
What a datastage macro?
How do you register plug-ins?
Distinguish between informatica & datastage. Which one would you choose and why?