How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
- 2 Answers
- 5142 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 |
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What is meant by incremental load?
SCD2 will work on only dimension tables as well as fact Table?
what is the use of structures?how many nodes can u create in a structure?
When do we go for the tools in the market?
What is tracing level? How many types of transformations supported by sorted input?
what is a test load?
Explain the difference between etl tool and olap tools?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What do you understand by active and passive transformations?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Teradata 
