Is it possible to search an expression code, in multiple informatica mappings with out manually going through the mapping? Say like exporting the mapping into an XML or anything similar.
Example : I need to search if we are using an expression where we check if a field is NULL like below :
IF(ISNULL(PORT1), CONDITION1, CONDITION2)
I need to search say N number of mappings to check if i am using ISNULL function anywhere in the mapping, as we are going to replace all the NULL's in the database with default values and setting all the fields to NOT NULL, and in the informatica logic, if we are explicitly checking for ISNULL conditions, we would have to recode the logic.
Basically i need to do impact analysis, and need to check if and where there is an ISNULL condition used, it should be replaced with default values instead. say the above condition looks like below :
IF(PORT1='', CONDITION1, CONDITION2)
Any assistance would extremely be appreciated.
Export all workflows from repository manager as a single xml. Then search for the expression. If this is something you need to do frequently, you can consider writing script utility script to do this and return the list of mapping names.