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 |
What does refresh system mean, and what are its distinctive choice?
What are the issues you have faced in your project? How did you overcome those issues?
What is sql query override? When did u use sql query override?
When to use normalization transformation other than cobol source?
What is the advantage of persistent cache? When it should be used.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
Which is better performance wise database or file?How?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
How would you join a node to the already existing domain?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks