what are testing in a mapping level please give brif
eplanation
Answer Posted / sambasivarao.m
Hi,
find below testing points at mapping level that might be
help you..
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 connection
Verify 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
Regards,
Sambasivarao.m
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is xml source qualifier transformation in informatica?
Define enterprise data warehousing?
How can we use batches?
How do you update the records with or without using update strategy?
What is union transformation in informatica?
How to extract sap data using informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How will the document be delivered to me?
What is meant by pre and post session shell command?
Why sorter is an active transformation?
Tell me about Propagate functions in informatica
How would you join a node to the already existing domain?
What is the difference between informatics 7x and 8x and what is latest version?