Q. What are testing in a mapping level please give brif eplanation?





Verify Mapping is Available Verify parameters are defined properly with proper
datatypes Verify whether the shorcut to source table is used as
source in the mapping from replica connectionVerify whether WHERE clause in the SQ has used properly to implement delta condition Verify whether the primary key is selected properly in the
target table Verify whether versioning is maintained Verify Source name used in the mapping
Verify Target name used in the mapping Changes made to the existing mapping(if applicable)
Verify whether the new fields handled for NULL values(if it  is a NOT NULL column in the Target table)
Verify whether lookup is added to the mapping(if applicable)
Verify whether the Lookup override used is proper
Vefify whether the condition for Insert/Update is used in
UPDATE STATERGY transformation
Verify Whether the Filter condition used is proper

No comments:

Post a Comment