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
- 5821 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 pmrep command?
what are the reporting tools and difference between them?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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.
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is factless fact schema?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
What is the main difference between peek stage and copy stage
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is session partitioning?
Explain the difference between etl tool and olap tools?
when should one create lookup transformation ?
Teradata 
