In real time scenario where can we use mapping parameters
and variables?

Answer Posted / pendekanti praveen kumar

Before using mapping parameters and mapping variables we
should declare these things in mapping tab of mapping
designer.

A mapping parameter cannot change untill the session has
completed unless a mapping variable can be changed in
between the session.

Example:::
if we declare mapping parameter we can use that parameter
untill completing the session,but if we declare mapping
variable we can change in between sessions.Use mapping
variable in Transcation Control Transformation......

Is This Answer Correct ?    39 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is aggregate cache in aggregator transformation?

637


have u done any performance tuning? how u ll do?

1861


Explain how many types of dimensions are available in informatica?

597


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1735


what is SDLC way of code development?

1564






What is event and what are the tasks related to it?

620


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1691


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601


list out all the transformations which use cache?

691


What are the different ways to implement parallel processing in informatica?

867


Explain the different lookup methods used in informatica?

590


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6757


Mention few advantages of router transformation over filter transformation.

642


What is mapplet in informatica?

598


Define filter transformation?

628