Sign Up Login


  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

Without using any transformations how u can load the data into target?

15 Answers   IBM,

What is the fact table?

0 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

what are the limitation of sorter transformation?

2 Answers   TCS,

Differentiate between a database and data warehouse?

0 Answers  

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

EXL informatica Questions

0 Answers  

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

Can we get 1st record through Informatica(without sequence number).

0 Answers  

can anyone suggest best free Talend data integration training online

0 Answers  

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

For more Informatica Interview Questions Click Here
Categories