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
- 5743 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 |
Compare etl & elt?
List few etl bugs?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What is a lookup table in etl?
Explain the use lookup tables and Aggregate tables?
what is the difference between date cache and lindex cache?
what is the use of server?
Difference between flat files and relational sources?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
What is partitioning? Explain different types of partitioning?
Mention few test cases and explain them?
Teradata 
