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.

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.

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

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.

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

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

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

What is session task and command task?

0 Answers  

In which circumstances that informatica server creates Reject files?

2 Answers  

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

How is Data Models Used in Practice?

1 Answers  

r u done any partitions in ur project?

0 Answers   TCS,

What is an expression transformation?

0 Answers  

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers