What are mapping parametres and variables in informatica?

Answers were Sorted based on User's Feedback



What are mapping parametres and variables in informatica?..

Answer / b.gopala rao

Mapping Parameters: Mapping parameter is a constant value
which points to any datatype in the entire mapping. its
value will not be changed as earlier said.

Mapping variable: Mapping variable is same thing like
mapping parameter except its value will be changed in the
mapping.

For define the value you can give the intial value or you
can create mapping parameter file. But in the file you
should specify the folder name. session name .
Ex:
[foldername.sessionname]
$$parameter1=100;
Otherwise informatica server can not recognize
the session.

Is This Answer Correct ?    36 Yes 2 No

What are mapping parametres and variables in informatica?..

Answer / bsgsr

mapping parameters and variables make the mappings reusable
and saves time. ex: u have created a mapping to load the
data of only deptno 10 into the target. next time if you
want to load the data of deptno 20 u have to create the
mapping again which is fom the scratch again. if you create
a parameter and define the value in the parameter file you
can simply change the value of the parameter and can use
the mapping again.

mapping parameter represents a constant value that doesnt
change during the session run where as mapping variable
represents a value which changes during the session run
and saves the max value to the repository which is used
next time when you run the session.

Is This Answer Correct ?    36 Yes 2 No

What are mapping parametres and variables in informatica?..

Answer / gopi

mapping parameter: it is a static.. the value cannot be
changed thorughout the session..
variable: it is dynamic..the value can be stored at the end
of session and the value cane be used next time run the
session

Is This Answer Correct ?    2 Yes 0 No

What are mapping parametres and variables in informatica?..

Answer / chandramohan reddy

Mapping parameter is a constant value that cannot be changed
during the mapping run.it is saved with an extension .PRM

Mapping variable is a value which can be changed during the
mapping run.

Is This Answer Correct ?    6 Yes 8 No

What are mapping parametres and variables in informatica?..

Answer / sid

you can change the value of a parameter in the mapping.The
new value will be stored in the repository.In case in the
next session run you for some reason fail to define the
parameter in the parameter file informatica will pick up
the last value form the reposiroty

Is This Answer Correct ?    2 Yes 9 No

What are mapping parametres and variables in informatica?..

Answer / raja

mapping parametres is constant value it should defines in
separately using mapping parametres create function provided
informatica server,
it use to create name,type,datatype,precision,scale.

mapping variable should varied when the each tome session
runs,it also use to create
name,type,precision,scale,aggreation.
it mainlyuse full for incremental load processing

Is This Answer Correct ?    5 Yes 15 No

Post New Answer

More Informatica Interview Questions

In which scenario did u used Mapping variable?

1 Answers   Cognizant,


following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


How do you change parameter when you move it from development to production.

1 Answers  


What do you understand by term role-playing dimension?

0 Answers  






What is the maplet?

0 Answers   Informatica,


my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


what is datamart

4 Answers   IBM, Informatica,


What is the difference between stop and abort in informatica

0 Answers   Informatica,


What is the sequence generator transformation in informatica?

0 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


Categories