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
Can we override a native sql query within informatica?
What is a rank transform?
What is the use of code page?
What are the different ways to implement parallel processing in informatica?
What is a snowflake schema?
What is Cognos script editor?
What are mapplets?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
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
What is the advantage of informatica?
is it possible to index the data in cache of lkp transformation ?
What is lookup transformation?
Differentiate between sessions and batches?
How to generate sequence numbers without using the sequence generator transformation?
Scheduling properties,whats the default (sequential)