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 |
How to create or import flat file definition in to the warehouse designer?
What is workflow manager?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
What is the status code?
What are the informatica performance improvement tips
What are the types of error logs available in Informatica?
What is the procedure to load the fact table.Give in detail?
what is sql override?what is the use of it?
Slowly changing dimensions, types and where will you use them
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai