Active Directory, AS/400, Business Intelligence, CIO, Cisco, Database, DataCenter, Desktops, Development, DNS, Exchange, Exchange 2003, Exchange 2007, Hardware, iSeries, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??
I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction...