Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is bridge tables in informatica

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we override a native sql query within informatica?

1039


What is a rank transform?

1086


What is the use of code page?

1096


What are the different ways to implement parallel processing in informatica?

1423


What is a snowflake schema?

996


What is Cognos script editor?

4235


What are mapplets?

1274


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121


What is the advantage of informatica?

1069


is it possible to index the data in cache of lkp transformation ?

2029


What is lookup transformation?

1042


Differentiate between sessions and batches?

1018


How to generate sequence numbers without using the sequence generator transformation?

1207


Scheduling properties,whats the default (sequential)

1956