Results 1 for
"sql hack"
SQL or PL/SQL for Hand coding ETL
Hi Wanted to get a general idea, as to what others have used when hand coding ETL for loading data into data marts. My thoughts : Straight inserts , updates, merges are faster, however can't capture errors. Pl/SQL is more flexible allowing to log error
Hi Wanted to get a general idea, as to what others have used when hand coding ETL for loading data into data marts. My thoughts : Straight inserts , updates, merges are faster, however can't capture errors. Pl/SQL is more flexible allowing to log error
How To Hack An Cola Machine
Coke machine crack Introduction Cola vending machines are everywhere. They have increasingly small computer on board, with LEDs that show little messages like "Ice Cold" etc. But there is more to do with that built computers. Included in
Coke machine crack Introduction Cola vending machines are everywhere. They have increasingly small computer on board, with LEDs that show little messages like "Ice Cold" etc. But there is more to do with that built computers. Included in
ETL from Oracle to SQL Server 2008 Data Warehouse
Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a
Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a
Partitioning Large MS SQL-Server FACT table
Scenario: Data should be retained for 5 years or 60 months. Table will have about 800 million records Have adapted monthly partition. Each File group have 8 files to match the Number of CPU improve parallelism. Each partition will be kept i
Scenario: Data should be retained for 5 years or 60 months. Table will have about 800 million records Have adapted monthly partition. Each File group have 8 files to match the Number of CPU improve parallelism. Each partition will be kept i
Audit Dimensions in SQL/SSIS 2008
I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for
I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for
Cognos 8 Report studio SQL problem
The project is working out the Average Net Selling Price. This is Grouped by Period and Average Net Selling Price(ANSP), and then working out the running total % of volume(KG) by ANSP. You then proportion the ANSP in to case statement buckets and wor
The project is working out the Average Net Selling Price. This is Grouped by Period and Average Net Selling Price(ANSP), and then working out the running total % of volume(KG) by ANSP. You then proportion the ANSP in to case statement buckets and wor
Multivalued Dimension, bridge table, and constraints using SQL Server 2005
I'm developing a healthcare claims data mart. The diagnoses fields in the claims data are being implemented as a multivalued dimension, which consequently requires a bridge table between FactClaims and DimDiagnosis. The bridge table contains two
I'm developing a healthcare claims data mart. The diagnoses fields in the claims data are being implemented as a multivalued dimension, which consequently requires a bridge table between FactClaims and DimDiagnosis. The bridge table contains two
SQL Server 2008 Date data type as dimension key
We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date
We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date
Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost
Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost
Android SQL Demo
Hi, SQL Demo This example shows how to interact with Android SDK internal database SQLite to perform a simple action of inserting and querying data from a database table and database display content. Our simple data format is: [row id] [time
Hi, SQL Demo This example shows how to interact with Android SDK internal database SQLite to perform a simple action of inserting and querying data from a database table and database display content. Our simple data format is: [row id] [time
SQL Server Analysis Services is dying!
There have been a heap of announcements this week at the PASS summit for SQL Server. In particular, Microsoft have gone down the road of moving away from SSAS over the next few versions of SQL Server, in favour of using in-memory cubes with Powerpivot and
There have been a heap of announcements this week at the PASS summit for SQL Server. In particular, Microsoft have gone down the road of moving away from SSAS over the next few versions of SQL Server, in favour of using in-memory cubes with Powerpivot and
SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete
The 'MERGE' statement in SQL 2008 seems a powerful tool for managing incremental ETL. Seems lots of examples of using from SSMS, but few (none?) of calling from within the SSIS framework. Hopefully in Denali we'll see a package object OOTB that can
The 'MERGE' statement in SQL 2008 seems a powerful tool for managing incremental ETL. Seems lots of examples of using from SSMS, but few (none?) of calling from within the SSIS framework. Hopefully in Denali we'll see a package object OOTB that can
Post ur UDIDs on this for every ifile hack and anything u want
This is my friends UDID acdfde1e8c47f2860c4d65817b7ff44c16e6cc32
This is my friends UDID acdfde1e8c47f2860c4d65817b7ff44c16e6cc32
"Previous" attributes
I am working on a HR Enterprise datawarehouse. I have a requirement for a number of "previous" attributes. For example, an employee's previous business unit, supervisor, last name. Business Unit, Manager already have their own Type 2 SCD
I am working on a HR Enterprise datawarehouse. I have a requirement for a number of "previous" attributes. For example, an employee's previous business unit, supervisor, last name. Business Unit, Manager already have their own Type 2 SCD
Bridge Table Problem in T-SQL
I have a T-SQL statement that is giving me problems. If the last part of the where clause is not included, runs in about 17 seconds against a 120GB DW/Star Schema SQL 2005 Enterprise Returns about 255000 rows out of about 25-30 million rows. If I
I have a T-SQL statement that is giving me problems. If the last part of the where clause is not included, runs in about 17 seconds against a 120GB DW/Star Schema SQL 2005 Enterprise Returns about 255000 rows out of about 25-30 million rows. If I
Results 1 to 15 on 75
for "sql hack"
for "sql hack"
Active topics
Popular topics
Unanswered topics
