without matching columns in two tables. how can you join
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
How to improve the performance of a session using sorter transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What is a stored procedure transformation?
how tokens will generate?
what is SDLC way of code development?
What is InformaticaPowerCenter?
Differentiate between reusable transformation and mapplet.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is flashback table ? Advance thanks
what is the difference between informatica6.1 and infomatica7.1
Define mapplet?
Define the various join types of joiner transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is mapping debugger?
What is workflow? What are the components of the workflow manager?