How much time 120 GB of source data in flat file should take to load into sql server based datawarehouse through DTS as ETL.
I am doing assessment for one of the datawarehouse where it takes 5 days. There are no validations , the data simply goes into different tables.
I am doing assessment of a present data warehouse.
I am shocked to see the design.
1. Logical data model and physical data model not in sync.
2. no keys between facts and dimension ie no star join.
3. No validation in ETL.
4. No exception handling in SQL procedures.
5. Views acts as fact tables...
I have a HP pavilion AMD XP laptop.I installed Linux 9 on it.Everything went ok but when i start linux it doesn't go into graphics mode , instead comes up with a blue window with a yes and no button.If I click no it goes into text mode and asks me enter login details.If I press yes there is an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.