How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
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 |
Can u access a repository created in previous version of Informatica?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is the advantage of persistent cache? when it should be used?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what are the production issues in datastage?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
what is SMP AND MPP?
Define Dynamic push down optmization?
What is etl tool in hadoop?
Which transformation we use to convert 'NA' to 'Not Available'
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
what is meant by drill through?(Mascot)