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
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is an Integration service in Informatica?
Enterprise data warehouse your projects phase by phase explain?
Different circumstance which drives informatica server to expel records?
How to elaborate tracing level?
What is the difference between router and filter?
What is workflow? What are the components of the workflow manager?
Make a note of the quantity vaults made in informatica?
What is the advantage of informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
explain about unit testing? in real time?
How many ways are there to create ports?
What happens when a session fails and you click on recover?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to extract sap data using informatica?