Answer Posted / latha

Lookup transformation: Based upon one/more keys the data is
retreived from one/more tables.

create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.

Define filter transformation?

1145

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1059

---

What happens when a session fails and you click on recover?

1170

---

How to go to the older version for a mapping?

1152

---

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?

1555

---

What is the benefit of session partitioning?

1157

---

Enlist the differences between database and data warehouse.

1164

---

How will the document be delivered to me?

1127

---

What is a joiner transformation?

1033

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1137

---

How we can create indexes after completing the loan process?

1250

---

Write the different tools in the workflow manager?

1112

---

r u done any partitions in ur project?

1862

---

Which transformation should we use to normalise the COBOL and relational sources?

1267

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289

---