5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

How we can create indexes after completing the load process?

0 Answers  

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

What are the different tools in workflow manager?

1 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---