Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

Is apache nifi an etl tool?

906


what is the use of server manager?

2052


Explain about power designer data modeling software?

796


explain the methodology of Data Warehousing?(Polaries)

1934


What are materialized views & where do we use them?

914


When do we go for the tools in the market?

874


how do u identify the changed records in operational data?

2469


Explain about round-robi?

1076


how do u set partition points in the mapping?

2522


how would u estimate the size of Aggregator transform data and index cache?

1918


What is abap? What are idocs?

915


what is granularity in Data ware House?

1653


what are the reporting tools and difference between them?

2001


What is the difference between project backlog and product backlog?

1439


Define Dynamic push down optmization?

2239