Answer / abhinav

Set variable:Sets the current value of a mapping variable to
a value you specify.
Exa:SETVARIABLE ($$Time, SYSDATE)

SetMaxVariable:Sets the current value of a mapping variable
to the higher of two values.

Exa:SETMAXVARIABLE ($$MAXITEMS, ITEMS)

What is polling?

1 Answers  

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

Explain the aggregator transformation?

0 Answers  

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---