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

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  


what is the size of u r project? and what is the size of source file?

1 Answers   HP,


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,


What is flashback table ? Advance thanks

0 Answers   Puma,


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


What is mapplet in informatica?

0 Answers  


"Change cache" in Informatica ?

2 Answers  


explain about lookup t/r?

1 Answers   IBM,


1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,


what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  


Categories