Interested to Buy Any Domain ? << Click Here >> for more details...
what are testing in a mapping level please give brif
eplanation
- 1 Answers
- 7906 Views
- CTS, I also Faced
- E-Mail Answers
Answer / 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 |
how to move the mappings from your local machine to claint place?
what are the deliverables?in your project?
How informatica recognizes mapping?
what is the size of your data warehousing?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Explain reference cursor?
How to view and Generate Metadata Reports?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to extract original records at one target & Duplicate records at one target?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Teradata 
