What is the Difference between SetVariable and setmaxvariable
in informatica?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Does an informatica transformation support only aggregate expressions?

698


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1588


What is informatica etl tool?

643


What is a code page?

799


if we have a delimiters at unwanted places in a flat file how can we over come those.

1648






What is repository manager?

632


How to use procedural logic inside infromatica?

733


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1868


Is stop and abort are same in informatica?

657


How do you use reject loader.

2186


What is the function of aggregator transformation?

666


What are the transformations that are not supported in mapplet?

681


What is workflow? What are the components of workflow manager?

808


Define update strategy?

717


Explain the different dimensions.

648