Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suraj kedia
A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.
It is an active transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of using informatica as an etl tool over teradata?
Global and Local shortcuts. Advantages.
Explain the different lookup methods used in 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
How you can differentiate between connected lookup and unconnected lookup?
What are roles and groups and benefits of using them?
What does “tail –f” command do and what is its use as an Informatica admin.
What is data movement mode in Informatica and difference between them?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is rank transform?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to update a particular record in target with out running whole workflow?
Briefly define a session task?
Explain scd type 3 through mapping.
What are the informatica performance improvement tips
