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...


Differentiate between mapping parameter and mapping variable?



Differentiate between mapping parameter and mapping variable?..

Answer / ysindhureddy77@gmail.com

A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.


A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.

 From the Session parameter file
 As stored in the repository object in the previous run
 As defined in the initial values in the designer
 Data type Default values

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to compare Source and Target table, without using dynamic lookup?

4 Answers  


explan ur project architecture?

0 Answers   TCS,


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


Reusable transformation and shortcut differences

0 Answers  


Explain about HLD and LLD ?

16 Answers   Accenture,


i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,


What are partitions in informatica and which one is used for better performance?

2 Answers  


What is a poling?

2 Answers  


What are mapping parametres and variables in informatica?

6 Answers   TCS,


As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  


How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,


without using emailtask how will send a mail from informatica?

3 Answers  


Categories