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

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

0 Answers   Informatica,


What is workflow manager?

0 Answers  


i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  


Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  


What is the status code?

1 Answers  


What are the informatica performance improvement tips

0 Answers   Informatica,


What are the types of error logs available in Informatica?

1 Answers  


What is the procedure to load the fact table.Give in detail?

1 Answers  


what is sql override?what is the use of it?

4 Answers   Sonata,


Slowly changing dimensions, types and where will you use them

0 Answers  


There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,


Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,


Categories