1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?

Question Posted / guest

Answers were Sorted based on User's Feedback



is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / mike

If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.

Is This Answer Correct ?    10 Yes 5 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / usha

we want join in SQ we should have primary key and foreign
key relation ship ...


but, in joiner we dont need primary key and foreign key
relation ship

Is This Answer Correct ?    0 Yes 0 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / bharu_295

if u want to join the tables we need to have primary and foreign key relationship other wise if we join we get Cartesian product of the data.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

How to update source definition?

0 Answers  

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

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

6 Answers   HCL, Schneider,




Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

What is informatica metadata and where is it stored?

0 Answers  

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

where to store informatica rejected data?

0 Answers  

Can you use one mapping to populate two tables in different schemas

2 Answers  

For more Informatica Interview Questions Click Here
Categories