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

Informatica and datawarehousing courses in Pune?

2 Answers  

Is there any model difference between ODS and DWH

2 Answers   Zensar,

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

What is aggregator transformation in informatica?

0 Answers  

What are the tasks that Loadmanger process will do?

1 Answers  

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

what is distinct

4 Answers  

How to update source definition?

0 Answers  

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,