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

What is update strategy transform?

0 Answers  

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

how to obtain performance data for individual transformations.

2 Answers  

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---