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
- 36996 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / reddevilzz
For mapping parameters, there cud be a scenario as below
Lets say I have a sql override as ,
Select emp_no, emp_name from emp where $$Hint1
In parameter file, I have $$Hint1 = dept_id in (1,2)
if $$Hint = <empty>, in parameter file, in this case the
mapping will fail because, SQ would not be able to prepare
the query,
In another scenario, i can have SQ override as
Select emp_no, emp_name from emp $$Hint1
In parameter file, I have $$Hint1 = where dept_id in (1,2)
if $$Hint = <empty>, in parameter file,
still the mapping will be executed.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica?
tell me about your project functionality
What is main use of mapplet?
What is the function of look up transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Which development components of informatica have the highest usage?
How are the sources and targets definitions imported in informatica designer?
difference between informatica 8.1.1 and 8.6
How to do unit testing in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is meant by LDAP users?
What is an expression transformation in informatica?
Why filter transformation is an active one?
What are the advantages of using informatica as an etl tool over teradata?
