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
- 34890 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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
Explain Dataware house architecture .how data flow from intial to end?
What is the difference between Active and Passive transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What can we do to improve the performance of informatica aggregator transformation?
What is the way to execute pl/sql script using informatica mapping?
How do you handle two sessions in Informatica
What are the main features of Oracle 8i with context to datawarehouse?
How do you convert single row from source into three rows into target?
What is complex mapping?
What is the difference between a repository server and a powerhouse?
Explain sessions. Explain how batches are used to combine executions?
How big was your fact table
What do you mean incremental aggregation?
