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
What are the different ways to implement parallel processing in informatica?
How to handle decimal places while importing a flatfile into informatica?
What are the differences between a connected lookup and unconnected lookup?
Explain target update override in informatica
How do you load alternate records into different tables through mapping flow?
Can u generate reports in Informatica?
how many types of dimensions are available in informatica?
Explain lookup transformation is active in informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Which development components of informatica have the highest usage?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain in detail about scd type 1 through mapping.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How is union transformation utilized?
permutations of mapplet