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
Explain and compare etl & manual development?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is staging area referring to?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain do we need an etl tool? When do we go for the tools in the market?
explain the methodology of Data Warehousing?(Polaries)
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
SCD2 will work on only dimension tables as well as fact Table?
What is a materialized view log?
What is the difference between project backlog and product backlog?
Explain about the data integration suite features?
Give the benefits of data integration suite?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Two default user groups created in the repository are____and_____.
What is lookup table in etl testing?