Answer Posted / abhinav

Mapping parameter is an option in Informatica where, at the
mapping level, you can specify the value to be used.

For example, if there is a field called START_DATE, the
value for this date can be specified by either passing it
as a variable at the mapping level or storing the value in
a parameter file, which will be read during the session is
run.

What are the restrictions of union transformation?

1033

---

What are the guidelines to be followed while using union transformation?

1134

---

Difference between Target-based loading and constraint-based loading?

990

---

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

1116

---

What is the use of an aggregator cache file?

1194

---

What is dimensional table? Explain the different dimensions.

1166

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1039

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2552

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2355

---

What is domain and gateway node?

1157

---

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

2140

---

Clarify the utilization of aggregator cache record?

987

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1627

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2344

---

how tokens will generate?

2194

---