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
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Which transformation should we use to normalise the COBOL and relational sources?
What is a rank transform?
scenario where i can use only concurrent execution of workflow.
waht type of interface is used for testing the data in informatica
What is the difference between a repository server and a powerhouse?
How do you load alternate records into different tables through mapping flow?
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?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Global and Local shortcuts. Advantages.
What is fact table? Explain the different kinds of facts.
Define mapping and session?
server hot-ws270 is connect to Repository B. What does it mean?
Can we override a native sql query within informatica?