Thursday, January 3, 2013

Informatica Mapplet parameters not getting intialized while running through DAC


(DATASOURCE NUM ID)
Mapplet parameters like $$ETL_PROC_WID are not getting intialized while running through DAC Are your mappings failing because mapplet parameters like $$ETL_PROC_WID are not getting intialized while running through DAC?
Reason: DAC doesn’t differentiate between a mapplet/ mapping parameter, This means that while initializing mapplet parameters DAC does not prefix mapplet name in the parameter file. Because the mapplet name is not prefixed, informatica is not passing values to mapplet parameter like $$ETL_PROC_WID
Solution : For this to work, we need to modify the custom property of Informatica Integration service.
Go to your integration service properties in Informatica Admin Console.  In Custom properties box, Add a Variable name – overrideMpltVarWithMapVar and set its value to Yes. (This variable enables the integration service to accept values for mapplet parameters even though the mapping name is not prefixed to the parameter name. Restart all informatica servers