without matching columns in two tables. how can you join
- 5 Answers
- 10051 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ankit kansal
Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sarthak
U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.
| Is This Answer Correct ? | 1 Yes | 4 No |
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Why filter transformation is an active one?
define galaxy repository in informatica
What are reusable transformations in how many ways we can create them?
How to merge First Name & Last Name?
what are the perameter and variable?
What is the Process to creating lookup transformation in informatica
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Which kind of index is preferred in DWH?
can we override a native sql query within informatica? Where do we do it?
what are the row and column separations in Flat Files
Teradata 
