For Data warehousing projects

InternetNews Realtime IT News - Apple Loses Bid to Dismiss iPhone Monopoly Suit
Earn Money Online! No Registration Fees. Guaranteed Payments.
http://www.moneycosmos.com/?r=364773

Instantly Turn your Computer into a Super TV. Enjoy iPod, PSP, IPhone, Movies, Music, MP3, TV Shows! - http://cbnk.biz/HLSTV364773RYRRGDK

Send SMS to India @ 1 Cent / SMS! Packs Start $2 Only - http://cbnk.biz/HL1CS364773RYRRGDK

Register (any name) .com website for 1 Year @ Rs.365 Only! Hurry! - http://cbnk.biz/HLDOM364773RYRRGDK

Win cash Rs.10,000. SMS BLUFF to 57333 (India Only) Free registration! - http://cbnk.biz/HLDDT364773RYRRGDK


 Quick Links:  GMail   Google Images   Google Maps   Orkut   Yahoo! Mail   Yahoo! Maps   Yahoo! Search   Live Search   Hotmail   Rediffmail  AOL  href="http://cnn.com/">CNN  SAAMA  Symantec  Genisys  Informatica  BusinessObjects 

Testing Types


The following are types of Testing performed for Data warehousing projects.
1. Unit Testing.
2. Integration Testing.
3. Technical Shakedown Testing.
4. System Testing.
5. Operation readiness Testing
6. User Acceptance Testing.
Unit Testing
The objective of Unit testing involves testing of Business transformation rules, error conditions, mapping fields at staging and core levels.
Unit testing involves the following
1. Check the Mapping of fields present in staging level.
2. Check for the duplication of values generated using Sequence generator.
3. Check for the correctness of surrogate keys, which uniquely identifies rows in database.
4. Check for Data type constraints of the fields present in staging and core levels.
5. Check for the population of status and error messages into target table.
6. Check for string columns are left and right trimmed.
7. Check every mapping needs to implement the process abort mapplet which is invoked if the number of record read from source is not equal to trailer count.
8. Check every object, transformation, source and target need to have proper metadata. Check visually in data warehouse designer tool if every transformation has a meaningful description.