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
- 5588 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the use of server manager?
Compare etl & elt?
Explain what are the various etl tools in the market?
What are materialized views & where do we use them?
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?
What are the steps involved in etl process?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Explain me ETL project architecture in Detail?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What are the ETL Testing Operations?
Identifying the bottlenecks in various components of Informatica and resolving them.
how do u really know that paging to disk is happening while u are using a lookup transform?
Do we need an etl tool?
list and discuss two approaches for updation of target table in Informatica and how they are different.
