Interested to Buy Any Domain ? << Click Here >> for more details...
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
To import the flat file definition into the designer where should the flat file be placed?
What are the differences between oltp and olap?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain lookup transformation is active in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the different lookup cache(s)?
How do you load only null records into target?
How to load the data from a flat file into the target where the source flat file name changes daily?
Write the unconnected lookup syntax and how to return more than one column.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How can we use mapping variables in informatica? Where do we use them?
How to go to the older version for a mapping?
What is depict expression change?
What is the difference between a repository server and a powerhouse?
