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

What is the session task and command task?

601

---

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

837

---

How to generate sequence numbers using expression transformation?

646

---

Mention few power centre client applications with their basic purpose?

539

---

What is a sorter transformation?

664

---

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1077

---

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

627

---

permutations of mapplet

2042

---

waht type of interface is used for testing the data in informatica

1835

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1941

---

What is aggregator transformation in informatica?

545

---

What is xml source qualifier transformation in informatica?

714

---

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

698

---

What is domain in terms of informatica?

567

---