what are testing in a mapping level please give brif
eplanation
- 1 Answers
- 7067 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 |
Can a joiner be used in a mapplet.
Explain joiner transformation in informatica
Is it possible to revert a global repository to local one and why?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What do you mean incremental aggregation?
explain abt union t/r?
What is rank transformation?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
what is polling?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Teradata 
