Answer Posted / jagan

Value of mapping parameter remain constant for a session run. Server reads its value on every run from parameter file. its value can not be changed at the time of session execution. When ever next time session runs, it reads the parameter value again from parameter file.

what is informatica metadata?

1088

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2443

---

where to store informatica rejected data? How to extract the informatica rejected data?

1053

---

What does “tail –f” command do and what is its use as an Informatica admin.

1147

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2192

---

What is union transformation in informatica?

1192

---

How are indexes created after completing the load process?

1718

---

How to update source definition?

1141

---

What is fact table? Explain the different kinds of facts.

1123

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

---

Write the program through which the records can be updated?

1053

---

Why filter transformation is an active one?

1032

---

When do you use sql override in a lookup transformation?

1140

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1554

---

What is main use of mapplet?

1176

---