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


Please Help Members By Posting Answers For Below Questions

How to improve the performance of a session using sorter transformation?

704


What does “tail –f” command do and what is its use as an Informatica admin.

637


What is a stored procedure transformation?

620


how tokens will generate?

1745


what is SDLC way of code development?

1570






What is InformaticaPowerCenter?

702


Differentiate between reusable transformation and mapplet.

592


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.

1863


What is flashback table ? Advance thanks

1497


what is the difference between informatica6.1 and infomatica7.1

1729


Define mapplet?

634


Define the various join types of joiner transformation?

568


To import the flat file definition into the designer where should the flat file be placed?

683


What is mapping debugger?

577


What is workflow? What are the components of the workflow manager?

652