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
- 5822 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
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is abap? What are idocs?
what are Lookup caches options? Including persistent caches.
explain the methodology of Data Warehousing?(Polaries)
what is data modeling?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Difference between flat files and relational sources?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the three tiers in etl?
How many steps etl contains?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the difference between cardinality and Nullability?
What is Data Vault???
What do you understand by active and passive transformations?
What do you understand by the term ‘transformation’?
