what are the facilities provided by data warehouse to
analytical users?
No Answer is Posted For this Question
Be the First to Post Answer
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
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
Explain what is etl process? How many steps etl contains explain with example?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
working of line item dimension......pls,tell overall flow
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 tracing level and what are the types?
Hi, Lookup() is what kind of join ?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Eliminating of duplicate records without using dynamic lookups
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?