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...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

How can we handle Rejection Logic in Source tables while we
are matching the data in Target side in ETL Testing ?

Question Posted / alekya

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


Please Help Members By Posting Answers For Below Questions

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2004

what are the concerns of OLTP and DSS systems?

2504

What are your responsibilities as an etl tester?

1245

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2527

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2254

what are the session parameters? How do u set them?

2090

What are the types of Data Warehouse applications?

1077

Explain about the data integration suite features?

992

what are the reporting tools and difference between them?

2143

Compare etl & elt?

1053

what do u do when DB time takes more?in sap bi

2240

what is the difference steps for data modeling?

2645

What is etl tool in hadoop?

947

what are the types in error loging?

2191

What are the etl testing operations includes?

1151