What are the basic needs to join two sources in a source
qualifier?

Answers were Sorted based on User's Feedback



What are the basic needs to join two sources in a source qualifier?..

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

What are the basic needs to join two sources in a source qualifier?..

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

What are the basic needs to join two sources in a source qualifier?..

Answer / ravi

1) both tables should have PK-FK relationship
2) both should have matching datatypes.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Informatica Interview Questions

What does refresh system mean, and what are its distinctive choice?

0 Answers  


What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,


What is sql query override? When did u use sql query override?

1 Answers   TCS,


When to use normalization transformation other than cobol source?

2 Answers  


What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,






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?

0 Answers  


How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  


Which is better performance wise database or file?How?

2 Answers   TCS,


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


How would you join a node to the already existing domain?

0 Answers  


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

1 Answers   IBM,


Categories