I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dim开发者_开发问答ension tables and my fact table, primary keys etc.
I would like to be able to produce a file by running a command or batch which basica开发者_如何学Clly exports a table or view (SELECT * FROM tbl), in text form (default conversions to text for dates,
Just looking for a component that can be programmatically called in a fairly simple way to import a flat file of data.The data is typically 100,000-500,000 rows, each row contains about 200 fields of
Please tell the concept of AbInitio recovery file. When the Abinitio graph fails in execution which cases shou开发者_如何学Gold we rollback the recovery file and in which cases we shouldnt rollbac
Here\'s the background. We have a few different customers, each with a different backend source database.We want to be back to pick up real time changes to the backend database, then transform the da
I was thinking of putting staging tables and stored procedures that update those tables into their own schema.Such that when importing data from SomeTable to the datawarehouse, I would run a Initial.S
I am creating a ETL process in MS SQL Server and I would like to have errors specific to a particular column of a particular row.For example, the data is initially loaded from excel files into a table
Closed. This question does not meet Sta开发者_高级运维ck Overflow guidelines. It is not currently accepting answers.
We have a process that is getting data in real time and adding records to a database. We\'re using SQL Server 2008 Integration Services to run our Extrac开发者_如何学运维t Transform Load (ETL) process
is it ok to set recovery mode simple in a staging db for an ETL process... The customer is not even doing a regular backup! So what\'s the point in keeping t开发者_运维百科he transaction logs...
加载中,请稍侯......