Interested to Buy Any Domain ? << Click Here >> for more details...
what are testing in a mapping level please give brif
eplanation
- 1 Answers
- 8080 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 a difference between complete, stop and abort?
What is sorter transformation?
What is union transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain lookup transformation is active in informatica
What is a pre-defined event and user-defined event?
What is the fact table?
What is domain in terms of 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?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Could you explain what is enterprise data warehouse?
What is substr in informatica?
What is source qualifier transformation in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
