What are the basic needs to join two sources in a source
qualifier?
Answers were Sorted based on User's Feedback
Answer / sameer
1) Both sources should be from same Database.
2) They should have a common field which can be used for a
join.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
1. two sources must be from same datbase.
2.there should be primary-foreign key relationship between
them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi
1) both tables should have PK-FK relationship
2) both should have matching datatypes.
| Is This Answer Correct ? | 4 Yes | 2 No |
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
why we use materialized view over view?
what is shared Cache. when we will use shared Cache?
what is SDLC way of code development?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
how DTM buffer size and buffer block size are related
Explain the use of aggregator cache file?
what is informatica metadata?
what is the function of 'F10' informatica ?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
What are the disadvantages of Sequence Generator T/R?
What is diff joiner and lookup