What are the basic needs to join two sources in a source
qualifier?
Answer Posted / ravi
1) both tables should have PK-FK relationship
2) both should have matching datatypes.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How you can differentiate between connected lookup and unconnected lookup?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the differences between joiner transformation and source qualifier transformation?
Why union transformation is an active transformation?
Explain the aggregator transformation?
How to update source definition?
Plz can any one say me how to get the informatica certification materials and dumps
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Write the unconnected lookup syntax and how to return more than one column.
What are the different types of repositories created using informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are multi-group transformations?
What is a grid in Informatica?