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
- 5593 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 etl process. How many steps etl contains explain with example?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are the different forms of normalization?
What is the main difference between peek stage and copy stage
Explain about power designer data modeling software?
What are materialized views & where do we use them?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
when will use SQL override in a lookup transformation?
Explain the key challenges that you face while performing etl testing.
What is grain of fact?
how do u implement configuration management in Informatica?
What is cube grouping?
Teradata 
