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 ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you manage the Parameter files while migrating your data from one environment to another environment?

555


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

639


Which transformation should we use to normalise the COBOL and relational sources?

748


What is a rank transform?

678


scenario where i can use only concurrent execution of workflow.

2551






waht type of interface is used for testing the data in informatica

1837


What is the difference between a repository server and a powerhouse?

820


How do you load alternate records into different tables through mapping flow?

1298


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1036


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


Global and Local shortcuts. Advantages.

1472


What is fact table? Explain the different kinds of facts.

616


Define mapping and session?

587


server hot-ws270 is connect to Repository B. What does it mean?

1859


Can we override a native sql query within informatica?

632