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 are the prerequisite tasks to achieve the session partition?

1209

---

update strategy transformation in informatica

1037

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1078

---

what are the Methods For Creating Reusable Transformations?

1127

---

Informatica settings are available in which file?

954

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1895

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1068

---

How to generate sequence numbers using expression transformation?

1044

---

What is a router transformation?

1079

---

Explain the scenario which compels informatica server to reject files?

1126

---

What is the use of transformation?

971

---

what is unit testing?tell me proceedure

2189

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1051

---

difference between informatica 8.1.1 and 8.6

3647

---

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

1029

---