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 eliminate duplicates in FF and oracle both
without matching columns in two tables. how can you join
how to load rows into fact table in data warehouse
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
what is bridge tables in informatica
what is the diff b/w union and joiner and lookup?
How can you define a transformation? What are different types of transformations in Informatica?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
How to do the error handling of if ur source is flatfiles?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Howmany ways yoU can update a relational source defintion and what are they?