without matching columns in two tables. how can you join
- 5 Answers
- 9700 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 |
What are the popular informatica products?
What happens if the info. Server doesn't find the session parameter in the parameter file?
what is the use of Java Transformation in Informatica 8.x?
what is meant by data driven.. in which scenario we use that..?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
what is materialized view?
What is the format of informatica objects in a repository?
Is snow flake or star schema used? If star schema means why?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
What is the session task and command task?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What are the different types of Type2 dimension maping?
Teradata 
