if u want to join the tables we need to have primary and foreign key relati

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

Question Posted / bharu_295

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

hi real timers . iam waiting for ur reply regarding ETL TESTING

2206

What is an expression transformation?

968

How can we delete duplicate rows from flat files?

1162

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1000

Target increases every day even though no new record was inserted

1514

According to his methodology what all you need before you build a datawarehouse

1689

can we override a native sql query within informatica? How do we do it?

1051

As union transformation gives UNION ALL output, how you will get the UNION output?

1039

What is meant by target load plan?

914

Performance tuning( what you did in performance tuning)

1908

what is $$$$?

2097

What is the function of look up transformation?

1054

Why update strategy and union transformations are active? Explain with examples.

1173

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986