what is bridge tables in informatica
Answer / 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 |
what is the difference between lookupoveride and joiner?
Design a mapping to get year of join for each employee.
what is constraint based load order
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can we override a native sql query within informatica? Where do we do it?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
How can repository reports be accessed without sql or other transformations?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
How to create the source and target database connections in server manager?
How to fix the etl bugs..Tell me the process?
In a sequential batch can u run the session if previous session fails?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com