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

if we have a delimiters at unwanted places in a flat file how can we over come those.

1560


What are the main features of Oracle 8i with context to datawarehouse?

1670


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548


Explain sql transformation in script mode examples in informatica

593


What is different between the data warehouse and data mart?

621






What is meant by lookup transformation? Explain the types of lookup transformation?

559


What is Index Caches size?

612


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1615


How many ways are there to do 'remove duplicate records in informatica'?

574


What is meant by pre and post session shell command?

610


What is meant by query override?

630


What is the cumulative sum and moving sum?

745


Different sorts of metadata that stores in the storage facility?

546


What are the different types of olap? Give an example?

551


Please let me know how to make Data masking in informatica..

1258