Interested to Buy Any Domain ? << Click Here >> for more details...
what are testing in a mapping level please give brif
eplanation
- 1 Answers
- 7872 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 |
what is target update override and when we use it?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
How can you display only hidden files in UNIX
Can you use one mapping to populate two tables in different schemas
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Without using Lookup & Sequence Generator, How to generate Sequence?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What is CDC? How to implement CDC?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is a joiner transformation?
Explain about perform recovery?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Teradata 
