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
- 5694 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the concerns of OLTP and DSS systems?
what are Lookup caches options? Including persistent caches.
how do u handle performance issues in Informatica . where can u monitor the performance ?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what is the use of server?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how do u set partition points in the mapping?
State the differences between shortcut and reusable transformation
what is a worklet?
Can we create Hierarchies in generic datasources?
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 ?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
