How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
Answer Posted / saravanan
use Minus query.
Select * from Source
minus
select * from Target
If you minus from Target, it will not gie you tHe Corret result sinCe all Values from target are from soure. We need to minus from sourCe. tHe rejeted reords wHICH are not populated into target will Come as result
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is apache nifi an etl tool?
what is the use of server manager?
Explain about power designer data modeling software?
explain the methodology of Data Warehousing?(Polaries)
What are materialized views & where do we use them?
When do we go for the tools in the market?
how do u identify the changed records in operational data?
Explain about round-robi?
how do u set partition points in the mapping?
how would u estimate the size of Aggregator transform data and index cache?
What is abap? What are idocs?
what is granularity in Data ware House?
what are the reporting tools and difference between them?
What is the difference between project backlog and product backlog?
Define Dynamic push down optmization?