How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
- 2 Answers
- 5056 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Define slowly changing dimensions (SCD)?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is SMP AND MPP?
where is the cache (lookup, index) created and how can you see it.
When do we go for the tools in the market?
Compare ETL & Manual development?
what are Lookup caches options? Including persistent caches.
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
Explain the use lookup tables and Aggregate tables?
what are the facilities provided by data warehouse to analytical users?
Explain about enterprise scalability and roi of data integration suite?
Teradata 
