Answer Posted / parameswarareddy
UNION
UNION ALL
MINUS
INTERSECT
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
Implementation methodology
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 do unit testing in informatica? How to load data in informatica ?
Explain the types of transformations?
In development project what is the process to follow for an etl developer from day1
Design a mapping to load a target table with the following values from the above source?
What are the differences between joiner transformation and source qualifier transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is source qualifier transformation in informatica?
Parameter and variable differences
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the use of source qualifier?