without matching columns in two tables. how can you join
Answer Posted / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What you know about transaction control transformation?
What is incremental aggregation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to create a non-reusable instance of reusable transformations?
What is a router transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain constraint based loading in informatica
How will the document be delivered to me?
What are the modules in Power Center
Explain incremental aggregation in informatica
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 do you load only null records into target?
What all are steps in up gradation of Informatica server?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the features of complex mapping?