Mappings are always validated when saved,can validated without Being saved. Output window will always Disply reason for invalidity Mappings are Getting validating Designer mainly validates 3 things.
1.Transformation validation
The Designer checks in the mapping whether all transformations are valid or not.
Ex:
------------------------------------------------------------------------------
10/20/2011 14:25:42 ** Saving... Repository Oracle_BI_DW_Base_Rep, Folder RAVI
------------------------------------------------------------------------------
Validating transformations of mapping M_EMP_SCD_TYPE1...
Look up Transformation LKPTRANS has empty condition. Transformation is not valid.
...there are invalid transformations.
Validating data flow of mapping M_EMP_SCD_TYPE1...
...data flow validation completed with no errors.
Parsing mapping M_EMP_SCD_TYPE1...
...parsing completed with no errors.
******** Mapping M_EMP_SCD_TYPE1 is INVALID ********
(or)
------------------------------------------------------------------------------
10/20/2011 11:52:10 AM ** Validating mapping M_TAR1
------------------------------------------------------------------------------
Validating transformations of mapping M_TAR1...
...transformation validation completed with no errors.
Validating data flow of mapping M_TAR1...
...data flow validation completed with no errors.
Parsing mapping M_TAR1...
...parsing completed with no errors.
******** Mapping M_TAR1 is VALID *******
(or)
------------------------------------------------------------------------------
10/20/2011 11:52:10 AM ** Validating mapping M_TAR1
------------------------------------------------------------------------------
Validating transformations of mapping M_TAR1...
...transformation validation completed with no errors.
Validating data flow of mapping M_TAR1...
...data flow validation completed with no errors.
Parsing mapping M_TAR1...
...parsing completed with no errors.
******** Mapping M_TAR1 is VALID *******
Here in these Examples You can see the order,i.e transformation validation,data flow validation and finally Parsing will be done.
2.Data Flow Validation
The Designer checks whether the data flow between the designer objects is Correct or not.
Ex:
-----------------------------------------------------------------------------
10/20/2011 13:12:40 ** Saving... Repository Oracle_BI_DW_Base_Rep, Folder RAVI
------------------------------------------------------------------------------
Validating transformations of mapping D_SIMPLE_PASS_DEPT...
...transformation validation completed with no errors.
Validating data flow of mapping D_SIMPLE_PASS_DEPT...
...(strict)link has incompatible data types: from M_dept: LOC to SQ_M_dept: LOC.
...there are data flow validation errors.
Parsing mapping D_SIMPLE_PASS_DEPT...
...parsing completed with no errors.
******** Mapping D_SIMPLE_PASS_DEPT is INVALID ********
3.Expression Parsing
Parsing Errors are nothing but Syntax Errors.
Ex:
-----------------------------------------------------------------------------
10/20/2011 13:12:40 ** Saving... Repository Oracle_BI_DW_Base_Rep, Folder RAVI
------------------------------------------------------------------------------
Validating transformations of mapping M_EMP_SCD_TYPE1...
...transformation validation completed with no errors.
Validating data flow of mapping M_EMP_SCD_TYPE1...
...data flow validation completed with no errors.
Parsing mapping M_EMP_SCD_TYPE1...
<<PM Parse Error>> [UPDAE_FLAG]: invalid symbol reference
... >>>>UPDAE_FLAG<<<<
...there are parsing errors.
******** Mapping M_EMP_SCD_TYPE1 is INVALID ********
Mappings validation in Bulk
Mappings can be validated in bulk,in two ways we can do.
1.Open powercenter Repository Manager,
select all or some of the mappings(Use ctrl or Shift,'ctrl+A' doesn’t work.),and Right Click then choose validate.
2.Use Queries Utility,In Designer's tools tab
Provide The Required Details as Shown in The Above Image. Press 'Blue Arrow' tab,And then select Mappings, after Selecting Mappings go to Tools and Select Validate.
No comments:
Post a Comment