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
=================

To import the flat file definition into the designer where should the flat file be placed?

1012

---

What is target designer and target load order?

1055

---

How to do unit testing in informatica?

1126

---

Design a mapping to load a target table with the following values from the above source?

1290

---

How to extract sap data using informatica? What is abap? What are idocs?

1093

---

What is the surrogate key?

1155

---

What are the tuning techniques you applied during your last project

1972

---

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

1168

---

Is it possible to create multiple domains on a single Informatica server?

1186

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1446

---

Plz can any one say me how to get the informatica certification materials and dumps

2005

---

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

1269

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1646

---

What is meant by lookup transformation?

1040

---

What is event and what are the tasks related to it?

1059

---