Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

Answer Posted / abhinaw prakash

You can write the query using both the source and target tables.

You can use the NOT IN and MINUS keyword.

Also you can make a mapping using both the tables and
generate a report on the missing records.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7766


What can we do to improve the performance of informatica aggregator transformation?

618


What are mapplets?

819


Explain where to store informatica rejected data? How to extract the informatica rejected data?

580


Performance tuning in UNIX for informatica mappings?

2139






difference between repository database and repository service?

621


Explain how to import oracle sequence into informatica?

590


What are the conditions needed to improve the performance of informatica aggregator transformation?

579


what are 3 tech challenges/ common issues you face?

1889


What all are steps in up gradation of Informatica server?

620


What is meant by a domain?

628


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1697


explain about unit testing? in real time?

1663


what is size of u r database?

1848


What is meant by incremental aggregation?

583