Explain why we use partitioning the session in informatica?

0 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

What are the different types of Type2 dimension maping?

1 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

---

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

---