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 |
How does the session recovery work.
Define Incremental Aggregation?
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
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?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
What is difference between Mapplet and reusable transformation?
Clarify the aggregator change?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What is the Router transformation?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
update strategy transformation in informatica