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
What is lookup transformation?
Explain what are the different versions of informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the Rank index port in Rank transformation?
What is a filter transformation and why it is an active one?
Define enterprise data warehousing?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are roles and groups and benefits of using them?
Explain how many types of dimensions are available in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to call shell scripts from informatica?
What is an expression transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the popular informatica products?
