what is bridge tables in informatica



what is bridge tables in informatica..

Answer / gangam rajesh

Bridge table is a association table between two multivalued
dimension tables i.e. which have many to many relation.
Actually database doesn't support m to m relationship so
by using this bridge table we convert the m to m relation
ship into two 1 to many relationships.Bridge table contains
primarykeys of both dimensional tables as a compositekey

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Informatica Interview Questions

In session log thier should not be a single error how will u do

3 Answers   HCL,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


Why do we need informatica?

0 Answers  


Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  


how to obtain performance data for individual transformations.

2 Answers  






hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,


i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,


why union is active transformation?

4 Answers   IBM,


I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


What is transformation?

0 Answers  


Categories