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
- 5738 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
What are the ETL Testing Operations?
How to fine tune mappings?
Explain different types of partitioning?
what are the reports developed in sap bw project and what is the requirement for developing it?
What is grain of fact?
how do u really know that paging to disk is happening while u are using a lookup transform?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is the difference between cardinality and Nullability?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how would u estimate the size of Aggregator transform data and index cache?
Define slowly changing dimensions (SCD)?
Explain about hash partitioning?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Difference between flat files and relational sources?
what are the concerns of OLTP and DSS systems?
