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

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

What is synonym?

2 Answers   Patni,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

What are the types of schemas we have in data warehouse.

0 Answers  

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

What is A complex mapping?

3 Answers   TCS,

---

What are the different clients of powercenter?

0 Answers  

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---