In real time scenario where can we use mapping parameters
and variables?
Answer Posted / pendekanti praveen kumar
Before using mapping parameters and mapping variables we
should declare these things in mapping tab of mapping
designer.
A mapping parameter cannot change untill the session has
completed unless a mapping variable can be changed in
between the session.
Example:::
if we declare mapping parameter we can use that parameter
untill completing the session,but if we declare mapping
variable we can change in between sessions.Use mapping
variable in Transcation Control Transformation......
Is This Answer Correct ? | 39 Yes | 7 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
can u any challenge your project?
what is size of u r database?
Differentiate between reusable transformation and mapplet.
Briefly define reusable transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
can we override a native sql query within informatica? Where do we do it?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How we can use union transformation?
scenario where i can use only concurrent execution of workflow.
is it possible to index the data in cache of lkp transformation ?
What is the difference between source qualifier transformations source filter to filter transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the difference between a repository server and a powerhouse?
draw informatica architecture 8.6 ?