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 domain and gateway node?
What differs when we choose the sorted input for aggregator transformation?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What is Code Page Compatibility?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
how to sort date field in infomatica?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the unsupported repository objects for a mapplet?
What is the use of source qualifier?
Under what condition selecting sorted input in aggregator may fail the session?
What is substr in informatica?