Answer / ratna

By using the normalizer transformation we can achieve this.

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

Describe data concatenation?

0 Answers  

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

what is update strategy transformation ?

7 Answers   TCS,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

how to load duplicate row in a target

4 Answers  

---