Interested to Buy Any Domain ? << Click Here >> for more details...
How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
- 2 Answers
- 5726 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 is a lookup table in etl?
Explain about enterprise scalability and roi of data integration suite?
Explain etl?
what is the difference between cardinality and Nullability?
How to delete data which is not in source table?
What is partitioning? Explain different types of partitioning?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is tracing level? How many types of transformations supported by sorted input?
can cubes contain measures ?
What are three tier systems in etl?
what is an ETL or ETT? And what are the different types?
what do u do when DB time takes more?in sap bi
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?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
How many types of transformations supported by sorted input?
