Answer Posted / maruthi
union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is mapping debugger?
What are the components of the workflow manager?
What are the types of caches in lookup?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to elaborate powercenter integration service?
Why union transformation is an active transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are roles and groups and benefits of using them?
Enlist few areas or real-time situations where informatica is required.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is informatica etl tool?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
