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
- 36691 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
What are pre and post-session shell commands?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Target increases every day even though no new record was inserted
How do we call shell scripts from informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is data transformation manager process?
Separate from an archive server and a powerhouse?
What are data-driven sessions?
In warehouses how many schemas are there?
What are the guidelines to be followed while using union transformation?
How to do unit testing in informatica? How to load data in informatica ?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we use mapping variables in informatica? Where do we use them?
What are the reusable transformations?
what is $$$$?
