Flat File Importing via SSIS - Best approach?

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

SSIS Frameworks. Automatic Rollbacks, and Poorly Designed OLTP Sources

I've purchased the excellent book Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution and read it cover to cover a few times.

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

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

Historical and Incremental Loading of Dimension and Fact tables

Hello I have been reading three of the Kimball books and playing with the MDWT_AdventureWorks_SSIS sample. I have learnt a lot but I have also become overwhelmed as I was new to DW/BI up until a few weeks ago. Also, the books are very detailed and ther

Importing file in selenium rc?

Hi, There are some of limitation of selenium tool which is not supported in current release and resaerch/development in going on it. One of them is file upload functionality. The upload functionality is working fine in ide during recording and

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Using NDK to Call C code from Android Apps

Hi, Using NDK to Call C code from Android Apps While Android SDK is great for application development, every once in a while you may need access to native code. This code is usually done in C. While you were able to access native code via Java Nativ

internationalist approach to resolve all outstanding issues between Iraq and Kuwait

Bwalun: internationalist approach to resolve all outstanding issues between Iraq and Kuwait Topic 6 has been read once 31/01/2011 Paris will seek to re-integration of Baghdad, the international community Baghdad, Omar Abdel-Latif Said French

File Renaming and Multilanguage Options

Hello there, first of all a big "THANK YOU" for this great programm!!! It's great to see trhat you help people organize theire data in an efficient an practicable way, that's really a big issue nowadays. When i looked at MC'S functions a

Easy way to deal with MKV files

Okay, so I know a lot of people seem to despise using MKVs when editing because for most people, they most don't want to ever work with a NL video editor, and the people who know how to covert them know of the hassle and the huge amounts of disk space

Subnetting

Konsep Subnetting, Siapa Takut? by Romi Satria Wahono Subnetting adalah termasuk materi yang banyak keluar di ujian CCNA dengan berbagai variasi soal. Juga menjadi momok bagi student atau instruktur yang sedang menyelesaikan kurikulum CCNA 1 program

Gimana ci cara bobol defreze 6???

ajarin donx bobol defreze 6??