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
- 5598 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
Explain etl?
tell me few points when u become TL
List few etl bugs?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what are the cubes developed in a sap bw project and what is the requirement for developing it?
How to fine tune mappings?
Is hadoop a etl tool?
explain the methodology of Data Warehousing?(Polaries)
Compare ETL & Manual development?
how would u estimate the size of Aggregator transform data and index cache?
what is a worklet?
what is Forward,Reverse and Re_engineering?
where we cannot use sorter Transformation. if we use then we will not get correct data?
