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 / 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
What is blocking transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How we can create indexes after completing the load process?
What is pmcmd command?
What are the tuning techniques you applied during your last project
Is it possible to create multiple domains on a single Informatica server?
What is expression transformation?
What are the components of workflow manager?
How can we use mapping variables in informatica? Where do we use them?
What is the meaning of up gradation of repository?
What does cheating measurement mean?
Plz can any one say me how to get the informatica certification materials and dumps
Enlist the various types of transformations.
Differentiate between source qualifier and filter transformation?
Parameter and variable differences