Showing posts with label experience. Show all posts
Showing posts with label experience. Show all posts

Tuesday, March 27, 2012

database beginner question

I've searched and could not find what I was looking for.
I have NO database experience but need to learn quick

I have an html page with an iFrame (flash menu on left - iFrame on right)
When I click a product image on the left this is what I need to happen.
- Flash send a variable
- The iFrame to load an HTML page that will populate with an image, 2 text fields, and 3 hyperlinks dependant on what product is clicked in the flash.

I am using access since it is what i have at work, and i can just add all the products in a table pretty quickly and easitly. I set up a table in access with the image, hyperlinks, and text that needs to populate in the html page. The HTML page is set up in tables if that makes a difference...

I just don't know where to go from here to make my connections and how to set it up.

Any help would be appreciated.

Thanks in advance.I would go to the Access forum

Saturday, February 25, 2012

Data Warehouse backup/recover

Hello, everyone:
Does any body have the experience to execute data warehouse backup/recover? What I want to know is how to backup/recover database in data warehouse and cubes.
Thanks.
ZYTdo you refer to facts/cubes that may get out of sync?
you might want to do the backup when there's no loading of facts/dimensions or have the loading processes do the cubes prior the loading of facts. Also, in case some batches are not processed 100% have some automated processes that check this and are able to repair (delete/reload batches).|||Thanks for reply. The difficult I have to face is I cannot connect database of OLAP,such as FoodMark2000, and cubes from backup box in EM. Any suggestions?

ZYT|||Do you get an error message?|||No. I mean I cannot find cube and database of DW in SQL Server Backup box.|||ok, so either no backup is being done at all or a third party tool is installed that does the backup. I hope this tool is able to connect to the sql-server though, otherwise the backups may not be so usefull afterall.