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
- 5728 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 is full load & incremental or refresh load?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
What are dimensions?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain what is etl process? How many steps etl contains explain with example?
Explain do we need an etl tool? When do we go for the tools in the market?
Which transformation we use to convert 'NA' to 'Not Available'
What are cubes and olap cubes?
what is session partitioning?
Can there be sub steps of etl steps?
what is HISTOGRAM? how to generate statistics?
Teradata 
