bozworth hollinz (5/10/2010)

---

I'm working on a strategy to deploy ddl changes to a schema. However, I have the requirement to maintain the data within the schema. Does anyone have a...

GSquared (2/3/2009)

---

I would like to point out that memorizing the answers to some probable interview questions is probably a good way to get job that you can't do and will...

Hi Malavika,

Concrete your fundamentals for Dimensional modelling even before you begin with any OLAP tool.

I woruld suggest you create checkpoint xml file and parse the content

:-):-):-)

if the package is passing QA and failing in Production it has to be an issue with permission

As a matter of fact you may employ a combination of XML configuration files which store the Connection string details(acting as a pointer to DB) and SQL tables for login...

Hi Ria,

This is simple. You have to use SQL Windowing functions such as ROW_NUMBER,RANK,DENSE_RANK with the OVER CLAUSE using Partition...:cool::cool::cool:

Hope this helps!!!

SQL Server Agent, but be sure you have enabled the Agent from Configuration Manager

:cool::cool::-)

What excaltly you mean by the word 'corrupted'?

Hi,

Please follow the url http://technet.microsoft.com/en-us/library/cc966399.aspx

Hope this helps.

Hi Sabarinathan,

Let us begin with the definition of each which will be followed by examples:

1. Additive measures: These are those specific class of fact measures which can be aggreagated across...

Hi Anil,

I still do not understand how does the SQL statement you implemented works fine...you still are refering the destination table.

And as mentioned earlier..this is brute force loading...

Priya,

You may use windowing functions(ROW_NUMBER,RANK,DENSE_RANK)

But this is a bad database design...I do not see a primary key constraint employed

Create variables....that suit your need:-D:-D:-D

Or use markers (?)

Vibin,

Out of box SSIS components will not meet your need.

You will have to code script tasks that meet your need