What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?

Answer Posted / karthiga

If mapping parameter and variable is used in the mapping
but nowhere defined or given, then session will fail.

we can define the Mapping parameter and variable using:
mappings>parameters and variables>declare parameters and
variables.
we will specify the value directly in default value or else
specify it in the parameter file.

Usually, we will specify in parameter file.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the command used to run a batch?

794


What is the scenario which compels informatica server to reject files?

846


How to update or delete the rows in a target, which do not have key fields?

920


What are the differences between source qualifier and joiner transformation?

828


Explain the shared cache and re-cache?

841


What is workflow? What are the components of workflow manager?

938


Explian the Process of deployment groups in informatica

838


Under which circumstances, informatica server creates reject files?

846


Can we create two repositories on same database instance in oracle?

862


Define mapping and session?

797


What are the modules in Power Center

1442


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

912


Explain Dataware house architecture .how data flow from intial to end?

2352


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1401


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

838