How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?
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
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 is the use of structures?how many nodes can u create in a structure?
Do we need an etl tool?
Can u access a repository created in previous version of Informatica?
can cubes contain measures ?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
what is Forward,Reverse and Re_engineering?
What is a lookup table in etl?
Explain do we need an etl tool? When do we go for the tools in the market?
What are the different Lookup methods used in Informatica?
what is session partitioning?
What are the various tools used in etl?
What is the difference between round-robin partitioning and hash partitioning?
Explain the key challenges that you face while performing etl testing.
can be used COM component in Informatica ?