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
What are the components of Informatica? And what is the purpose of each?
How to start a workflow using pmcmd command?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain joiner transformation in informatica
If informatica has its scheduler why using third party scheduler?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Is it possible to define a single node as a Gateway node as well as worker node?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the format of informatica objects in a repository?
draw informatica architecture 8.6 ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Why do you use Mapping Parameter and mapping variable?
have u done any performance tuning? how u ll do?
tell me 5 session failure in real time how can you solve that in your project?
Describe expression transformation?