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

Differentiate between source qualifier and filter transformation?

1508

---

What are batches?

1010

---

Why union transformation is an active transformation?

993

---

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

2057

---

Which is the t/r that builts only single cache memory?

1126

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

---

Differentiate between joiner and lookup transformation?

1048

---

What is sq transformation?

1079

---

What is source qualifier transformation in informatica?

946

---

can u any challenge your project?

1971

---

How to generate sequence numbers?

1029

---

What is resilience time?

1047

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

Define mapplet?

961

---

What is workflow monitor?

997

---