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
What are the etl testing operations includes?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the ETL Testing Operations?
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?
Explain and compare etl & manual development?
what make u disappointmnets in u r career
what is pmrep command?
What is etl process? How many steps etl contains?
Explain the key challenges that you face while performing etl testing.
what is data modeling?
how do use session mapping parameters ?(in which transformation)
Difference between flat files and relational sources?
what are the reporting tools and difference between them?
how many maximum session supports to multiload in teradata ??
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?