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

What are the types of presistent cache in look up tr.

0 Answers   IBM,


I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,


What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,






If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  


can we generate reports in informatica ? How?

3 Answers  


Explain what transformation and how many are there in informatica?

0 Answers  


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


Categories