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 are the challenges of Dataware housing in the future?
How many ways are there to do 'remove duplicate records in informatica'?
What is substr in informatica?
Explain transaction control transformation in informatica
What are the measure objects?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What does reusable transformation mean?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.