Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

What is informatica etl tool?

0 Answers  

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

---