Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EDW - Logically Integrated across multiple DBs v/s Single DB
We have 3 divisions lets say for discussion purposes A,B and C. B is the Core of the Warehouse since 4 years and now A wants to join in. Should we aim for a single Database to store all the Tables or should we have separate Databases for each division. If we have a single Database, there is a...- rohitrevo
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Automatic Data Generation Tool
Do u know of any data generation tool(preferably free and Windows based), which will enable us to load data into prebuilt tables. Basically generating test data. We have one SQL Generator, tool but is unix based and takes some time to learn. Please give the URL for downloading such a tool.- rohitrevo
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
How to use Informatica and Teradata support tools for DW
In a typical Data Warehousing environment, it is likely that we use ETL tools like Informatica, SAS, etc for extraction and cleansing and then using some Teradata utility like FastLoad or MultiLoad. While the data load from ETL tools like Informatica, SAS is done using ODBC, it is quite slow in...- rohitrevo
- Thread
- Replies: 2
- Forum: NCR: Teradata
-
Multi Dimensional Modelling in Teradata
Most of the databases like SQL Server 7, Oracle 9i, IBM Essbase have a multidimensional engine which allow OLAP analysis. But Teradata V2R4 does not have a multidimensional engine and if we have to make cubes we resort to cube building in OLAP front end tool like Microstrategy and Cognos...- rohitrevo
- Thread
- Replies: 4
- Forum: NCR: Teradata
