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

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

how to load duplicate row in a target

4 Answers  

---

How would you join a node to the already existing domain?

0 Answers  

---

What are the different types of olap? Give an example?

0 Answers  

---

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---