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 is dimensional table? Explain the different dimensions.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is intricate mapping?
What is incremental aggregation?
What is a connected transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the use of transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the different versions of informatica?
What do you mean incremental aggregation?
What are roles and groups and benefits of using them?
What are the types of lookup transformation?
Enlist the tasks for which source qualifier transformation is used.
What do you understand by a term domain?