Answer Posted / nirosha g

Use Expression Transformation for this.
Create variable port after the two input ports:
v_cumm_sal = v_cumm_sal+sal;
o_cumm_sal = v_cumm_sal;

Connect The ports id,sal and o_cumm_sal to target

Where can we find the throughput option in informatica?

1107

---

Explain the tuning lookup transformation - informatica

1044

---

Clarify the aggregator change?

1080

---

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 ?

2408

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2028

---

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

1207

---

What is a pre-defined event and user-defined event?

1082

---

whats the logic to load the lower level of granularity of data to fact table.

2309

---

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

2193

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2249

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339

---

Explain lookup transformation is active in informatica

1147

---

What is a repository manager?

1148

---

Explain the different dimensions.

1008

---

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

2599

---