How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?

Answer Posted / alekya

use Minus query.
Select * from target
minus
select * from Source

This will give all the rows of sorce data which are
rejected,that is not loaded into the target.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is session partitioning?

1752


What are the different etl testing categories as per their function?

750


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

3844


What are cubes and olap cubes?

743


what is pmrep command?

2131


What are the types of Data Warehouse applications?

699


What are the various tools used in etl?

740


how many steps are there in etl process?

718


What are dimensions?

792


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2246


what is the use of structures?how many nodes can u create in a structure?

1966


what is session partitioning?

1626


Two default user groups created in the repository are____and_____.

1811


how would u estimate the size of Lookup transform data and index cache?

1841


what are the reports developed in sap bw project and what is the requirement for developing it?

1945