What are bridge tables in informatica?

Bipin Kumar
Bipin Kumar

Posted On: Dec 30, 2020

 

A bridge table acts between a fact table and a dimension table. It is used to resolve many-to-many relationships between a fact and a dimension. The bridge table will contain only two dimension columns and key columns in both dimensions.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Cognizant Informatica interview questions

    What is Star schema in informatica?

    Star Schema in a data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. As its structure resembles a star so it is known as a star schema....

    Cognizant Informatica interview questions

    What is snow flake schema ?

    In the data warehouse, Snowflake Schema is a logical arrangement of tables in a multidimensional database...

    Cognizant Informatica interview questions

    How do remove duplicates values in informatica from DB and Flat file?

    distinct property(keyword) is used to eliminate duplicate rows in Informatica from a database and a flat-file. We can eliminate duplicate rows from the flat-file by using group by function in an aggr...