Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?
- 10 Answers
- 36994 Views
- Deloitte, I also Faced
- E-Mail Answers
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
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
What are the differences between a connected lookup and unconnected lookup?
Mention a few design and development best practices for informatica?
What are the restrictions of union transformation?
How do you handle two sessions in Informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the different types of repositories created using informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
tell me about your project functionality
What is the difference between writing a joiner query in ANSI style and THETA style?
What are roles and groups and benefits of using them?
How union transformation is used?
What is the use of code page?
