How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
- 2 Answers
- 5093 Views
- I also Faced
- E-Mail Answers
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
What are various etl tools in the market?
What is data modeling and data mining?
What is etl process? How many steps etl contains?
What is a mapping, session, worklet, workflow, mapplet?
what is data modeling?
What are the etl testing operations includes?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
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
what is the use of structures?how many nodes can u create in a structure?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is abap? What are idocs?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
how do u extract data from different data sources explain with an example?
What are the ETL Testing Operations?
What is tracing level and what are the types?
