What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?
Answer Posted / krishnam
If the MP or MV is not defined then infa server will take
the default values. The order is: First it will serch in
Parameter file for the values, then repository( in case of
MV), if the value is not found then it will look for
initial value. If it can not find the value it will take
default values.
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Differentiate between joiner and lookup transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
tell me 5 session failure in real time how can you solve that in your project?
difference between repository database and repository service?
What is a difference between complete, stop and abort?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
differences between service based and product based?
How do you convert single row from source into three rows into target?
What is joiner change?
what is $$$$?
In development project what is the process to follow for an etl developer from day1
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can you define user defied event?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)