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
Separate from an archive server and a powerhouse?
What are pre and post-session shell commands?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
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
How do you load unique records into one target table and duplicate records into a different target table?
What is Session and Batches?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Separate from a database, an information bazaar, and an information stockroom?
Write the advantages of partitioning a session?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the performance considerations when working with aggregator transformation?
What do you mean by worklet?
What is a sequence generator transformation?
What are the components of workflow manager?
What is meant by pre and post session shell command?