Interested to Buy Any Domain ? << Click Here >> for more details...
Hierarchy of DWH?
- 2 Answers
- 19030 Views
- Accenture, EDS, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
Data modeling
ETL process
BI process
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Explain degenerate dimension table?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are aggregate tables and aggregate fact tables?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are the main steps to build the data warehouse?
What are the various methods of getting incremental records or delta records from the source systems?
Explain difference between view and materialized view?
Explain what are the tasks that loadmanger process will do?
What is the working process for application.cfm?
What is pre-emptive and non-pre-emptive?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to improve session performance in aggregator transformation?
What is a Decision Tree Algorithm?
