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
Can we create multiple integration service on single repository?
how we can load rejected record's at run time?(not through bad files)
Write the unconnected lookup syntax?
What is a rank transform?
Tell me about MD5 functions in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the need of etl tools?
Design time, run time. If you don't create parameter what will happen
Which version configuration tool used in ur project?
Do you find any difficulty while working with flat files as source and target?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a stored procedure transformation?
Design a mapping to load a target table with the following values from the above source?
What are active and passive transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
