Interested to Buy Any Domain ? << Click Here >> for more details...
without matching columns in two tables. how can you join
- 5 Answers
- 11255 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is sq transformation?
How can we improve session performance in aggregator transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Parameter and variable differences
Explain sql transformation in script mode examples in informatica
What is dimensional table? Explain the different dimensions.
Why update strategy and union transformations are active? Explain with examples.
Sequence generator, when you move from develoment to production how will you reset
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How does a rank transform differ from aggregator transform functions max and min?
How do you take back up of repository?
What is the Rank index port in Rank transformation?
what is mean by complex business rule ?
Mention a few design and development best practices for informatica?
How to Create a folder using pmrep command?
