What are mapping parametres and variables in informatica?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Process to creating lookup transformation in informatica

574


How does the aggregator transformation handle null values?

693


What is sequence generator transformation in informatica?

614


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

626


Separate from an archive server and a powerhouse?

485






Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1838


What is meant by incremental aggregation?

576


What is data movement mode in Informatica and difference between them?

616


What is the way to execute pl/sql script using informatica mapping?

952


What is an Integration service in Informatica?

697


What is union transformation in informatica?

693


How can we create index after completion of load process?

590


What is expression transformation?

623


Differentiate between sessions and batches?

564


How would you join a node to the already existing domain?

671