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
- 35041 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 generate sequence numbers without using the sequence generator transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can we use mapping variables in informatica?
Separate from an archive server and a powerhouse?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
In informatica workflow manager, how many repositories can be created?
what is SDLC way of code development?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between informatica 7.0 and 8.0?
which one is better performance wise joiner or look up
What is a difference between complete, stop and abort?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the steps involved in the migration from older version to newer version of Informatica Server?
