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
Describe the impact of several join conditions and join order in a joiner transformation?
Is there any way to read the ms excel datas directly into informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are active and passive transformations?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain target update override in informatica
list out all the transformations which use cache?
What are the modules in Power Center
How does the aggregator transformation handle null values?
What is the fact table?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How does a sorter cache works?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How can you validate all mappings in the repository simultaneously?
wf dont have integration severances how you can run?