Answer Posted / b.gopala rao

Mapping Parameters: Mapping parameter is a constant value
which points to any datatype in the entire mapping. its
value will not be changed as earlier said.

Mapping variable: Mapping variable is same thing like
mapping parameter except its value will be changed in the
mapping.

For define the value you can give the intial value or you
can create mapping parameter file. But in the file you
should specify the folder name. session name .
Ex:
[foldername.sessionname]
$$parameter1=100;
Otherwise informatica server can not recognize
the session.

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1085

---

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

1141

---

What is a filter transformation?

987

---

State the differences between sql override and lookup override?

1112

---

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

1011

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1050

---

What are the differences between joiner transformation and source qualifier transformation?

1097

---

Explain the informatica workflow?

999

---

What is expression transformation?

1034

---

What are the limitations of joiner transformation?

1044

---

What is meant by active and passive transformation?

1031

---

which one is better performance wise joiner or look up

1025

---

Write the unconnected lookup syntax and how to return more than one column.

1049

---

What are ETL Tools?

1040

---

What are the components of the workflow manager?

1079

---