Answer Posted / swetha

Normalizer Transformation.When yoU drag the COBOL source in
to the mapping Designer workspace,the normalizer
transformation automatically appears,creating input and
output ports for every column in the source.

How many input parameters can exist in an unconnected lookup?

990

---

how many types of dimensions are available in informatica?

559

---

write a query to retrieve the latest records from the table sorted by version(scd)

631

---

Why is sorter an active transformation?

663

---

What is target load order?

805

---

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1703

---

What is the difference between Active and Passive transformation?

631

---

Define enterprise data warehousing?

634

---

what is INFORMATICA TESTING process

1838

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2426

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

613

---

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?

1045

---

Target increases every day even though no new record was inserted

1105

---

Separate from a database, an information bazaar, and an information stockroom?

605

---

What is Data Caches size?

652

---