Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the Difference between SetVariable and setmaxvariable
in informatica?

Question Posted / jey.dgl


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

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

What is standalone command task?

0 Answers  

Differentiate between joiner and lookup transformation?

0 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

Can we run session without using workflows?

5 Answers   TCS,

What are the types of caches in lookup? Explain them.

0 Answers  

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

In development project what is the process to follow for an etl developer from day1

0 Answers  

For more Informatica Interview Questions Click Here
Categories