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
- 36183 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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me about your project functionality
What is joiner transformation?
what is index?how it can work in informatica
What is a surrogate key?
What is an expression transformation in informatica?
What does role playing dimension mean?
Enlist the tasks for which source qualifier transformation is used.
What are pre and post-session shell commands?
What is the difference between router and filter?
How does a sorter cache works?
What is exclusive and normal mode for repository services?
How to load the data from people soft hrm to people soft erm using informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
