Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

How to update source definition?

0 Answers  

What are some examples of informatica etl programs?

0 Answers  

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

What is workflow? What are the components of the workflow manager?

0 Answers  

What is the surrogate key?

0 Answers  

For more Informatica Interview Questions Click Here
Categories