what are testing in a mapping level please give brif
eplanation
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 the flow?
Difference between session variables and workflow variables?
If we have lookup table in workflow how do you trouble shhot to increase performance?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Enlist the various types of transformations.
What is Cognos script editor?
What is standalone command task?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
How do you migrate data from one environment to another?
Define error Threshold?
in which situations do u go for scds ?
How can we use mapping variables in informatica? Where do we use them?