is it reqire primary key and foreign key relation ship to join relational datab

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

Question Posted / guest

3 Answers
8471 Views
IBM, I also Faced
E-Mail Answers

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

What are the types of lookup?

3 Answers Wipro,

What is the Difference between DSS & OLTP?

5 Answers

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers IBM,

What are the Differences between static cache and dynamic cache?

1 Answers

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers TCS, Wipro,

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers DELL,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers TCS,

Enlist the advantages of informatica.

0 Answers

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers

For more Informatica Interview Questions Click Here