i have two source data there is no pk,fk how to join the
two sources
Answer Posted / prathap
if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
How we can create indexes after completing the load process?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is workflow? What are the components of workflow manager?
How many ways are there to do 'remove duplicate records in informatica'?
What is a filter transformation?
Mention few power centre client applications with their basic purpose?
What is Cognos script editor?
Briefly describe lookup transformation?
What is rank transformation?
Write the advantages of partitioning a session?
What are the settings that you use to configure the joiner transformation?
Explain the pipeline partition with real time example?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Enlist the advantages of informatica.