Explain scd type 3 through mapping.

0 Answers  

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What is status code?

2 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

What is active and passive transformation?

10 Answers  

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---