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
- 36281 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 to configure mapping in informatica?
Differentiate between a repository server and a powerhouse?
Why do you use Mapping Parameter and mapping variable?
How many types of sessions are there in informatica.please explain them?
Can we change Dynamic to Static or Persistent cache? If so what happens?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to join three sources using joiner? Explain though mapping flow.
What is native users?
What is an unconnected transformation?
Explain pushdown optimization and types in informatica
What is the different lookup cache(s)?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are pre and post-session shell commands?
What is sq transformation?
