without matching columns in two tables. how can you join
- 5 Answers
- 9740 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 |
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
How u use pdf file in informatica source?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
How to fix the etl bugs..Tell me the process?
What is the procedure for creating independent data marts from informatica 7.1?
What are active transformations.
What is a snowflake schema?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
hw cn v elimate dublicate values from lookup without overriding sql?
How to retrieve last two days updated records?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Teradata 
