Answer Posted / moorthy. g

S-SQ-Exp-Rtr-Tgt1/Tgt2

Exp:

flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;

Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values

Best Regards,
Manthiramoorthy. G

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

1081

---

What are the data movement modes in informatica?

1175

---

Explain target update override in informatica

1135

---

What are mapplets? How is it different from a Reusable Transformation?

1106

---

What is a dimensional model?

994

---

Explain how to import oracle sequence into informatica?

1028

---

What are the types of caches in lookup?

1057

---

Explain scd type 3 through mapping.

1025

---

What are the prerequisite tasks to achieve the session partition?

1264

---

While migrating the data from one environment to another environment how would you manage the connections?

1099

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1175

---

difference between repository database and repository service?

1163

---

What's the layout of parameter file (what does a parameter file contain?)?

2396

---

Differentiate between router and filter transformation?

1020

---

What is rank transform?

1008

---