What is the Difference between SetVariable and setmaxvariable
in informatica?



What is the Difference between SetVariable and setmaxvariable in informatica?..

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)

Is This Answer Correct ?    9 Yes 3 No

Post New Answer

More Informatica Interview Questions

How does the session recovery work.

1 Answers  


Define Incremental Aggregation?

2 Answers  


1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,


The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  






What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,


Clarify the aggregator change?

0 Answers  


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


What is the Router transformation?

2 Answers   Informatica,


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


update strategy transformation in informatica

0 Answers   Informatica,


Categories