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 |
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
Why union transformation is an active transformation?
How to improve the performance of a session using sorter transformation?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
how lookup is acting as both active and passive ? how is it possitble?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
How to delete duplicate row using informatica?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
How to delete first 3 rows & last 3 rows in target table in informatica
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
how many data models u have done in informatica project?