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 are the etl testing operations includes?

585


how do u handle performance issues in Informatica . where can u monitor the performance ?

4268


What are the ETL Testing Operations?

621


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3318


Explain and compare etl & manual development?

525






what make u disappointmnets in u r career

1784


what is pmrep command?

1956


What is etl process? How many steps etl contains?

596


Explain the key challenges that you face while performing etl testing.

573


what is data modeling?

1902


how do use session mapping parameters ?(in which transformation)

1442


Difference between flat files and relational sources?

1733


what are the reporting tools and difference between them?

1591


how many maximum session supports to multiload in teradata ??

1694


How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1835