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 transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1229

---

Define joiner transformation?

1102

---

What are the modules in Power Center

1718

---

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

1577

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2190

---

How to go to the older version for a mapping?

1157

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1019

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2029

---

Explain the scenario which compels informatica server to reject files?

1208

---

Please let me know how to make Data masking in informatica..

1772

---

Is it possible to use a client with different version than that of its Informatica server?

1190

---

How do you load unique records into one target table and duplicate records into a different target table?

1316

---

which one is better performance wise joiner or look up

1149

---

What is the use of transformation?

1054

---

Enlist the tasks for which source qualifier transformation is used.

1075

---