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
- 1 Answers
- 2574 Views
- I also Faced
- E-Mail Answers
Answer / Meenu Singh
To test a Data Warehouse project with Scriptella and Pentaho, you can follow these steps:
1. Create test datasets: Develop sample data that covers various scenarios to test the accuracy of your ETL scripts.
2. Unit Testing: Write unit tests for each script using a testing framework such as JUnit or NUnit.
3. Data Profiling: Analyze the statistical properties of both source and target data after running the ETL scripts.
4. Data Validation: Verify the integrity of the data by implementing business rules and constraints.
5. Load Testing: Load test your data warehouse to ensure it can handle the expected volume, velocity, and variety of data.
6. End-to-End Testing: Run reports using Pentaho to verify that the correct data is being processed and presented in the desired format.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is the difference between cubes and package in cognos
what is session partitioning?
working of line item dimension......pls,tell overall flow
what are the different forms of normalization?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
What are three tier systems in etl?
Explain about round-robi?
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.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
what are the concerns of OLTP and DSS systems?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Teradata 
