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?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
if u can't find what you are looking for in lookup table, how do you handle?
what is pmrep command?
When do we analyze the tables?
what is dynamic insert?
Can there be sub steps of etl steps?
What are various etl tools in the market?
What is tracing level? How many types of transformations supported by sorted input?
what is Forward,Reverse and Re_engineering?
how do u extract data from different data sources explain with an example?
Explain the difference between etl tool and olap tools?