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
- 5734 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 |
Explain different types of partitioning?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the facilities provided by OLAP to analytical users?
Explain do we need an etl tool? When do we go for the tools in the market?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the indicator file and where it is used?
How many steps etl contains explain with example?
what is the advantage of persistent cache? when it should be used?
What are the different Lookup methods used in Informatica?
Explain the key challenges that you face while performing etl testing.
Explain etl mapping sheets?
how would u estimate the size of Lookup transform data and index cache?
Teradata 
