Answer Posted / parameswarareddy
UNION
UNION ALL
MINUS
INTERSECT
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
What is blocking transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
expain about the tune parameters?
Why update strategy and union transformations are active?
What is the reusable transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
To import the flat file definition into the designer where should the flat file be placed?
What is a dimensional model?
Can anyone tell me the new features in Informatica 9 Version?
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?
Performance tuning( what you did in performance tuning)
What is a grid in Informatica?
Define joiner transformation?
Which version configuration tool used in ur project?