Answer Posted / moorthy g

Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female

Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================

What is a router transformation?

1210

---

What do you understand by SOA of Informatica?

1041

---

Enlist the various types of transformations.

1118

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186

---

Is it possible to revert a global repository to local one and why?

1129

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2406

---

What is meant by active and passive transformation?

1189

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2246

---

What is the cumulative sum and moving sum?

1233

---

What is a transaction control transformation?

1259

---

What differs when we choose the sorted input for aggregator transformation?

1070

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1331

---

What are the different transaction levels available in transaction control transformation?

1270

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1127

---

Have you worked with/created Parameter file

1710

---