Interested to Buy Any Domain ? << Click Here >> for more details...
what are testing in a mapping level please give brif
eplanation
- 1 Answers
- 7900 Views
- CTS, I also Faced
- E-Mail Answers
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 xml source qualifier transformation in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
What are the popular informatica products?
How might one distinguish in the case of mapping is right or not without associating session?
Why update strategy and union transformations are active?
Explain in detail about scd type 1 through mapping.
What is meant by LDAP users?
Explain what is informatica metadata and where is it stored?
generate date / time dimension in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is decode in informatica?
What is DR strategy for Informatica project?
Clarify the aggregator change?
According to his methodology what all you need before you build a datawarehouse
