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 |
How to extract sap data using informatica? What is abap? What are idocs?
What are Target Options on the Servers?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
can we override a native sql query within informatica? How do we do it?
How to load query faster,so that It will take less time to load?
what is the diff b/w cached and unchaed look ups
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Tell me about informatica architecture.
what is index?how it can work in informatica
how do u fnd the duplicate rows and how to delete the duplicate rows?