KoldCoffee (2/4/2015)

---

Hi Nevyn, yes I'm doing one big merge statement from stage to final table. So, you are saying there is better approach. Will you please say more about rhe...

KoldCoffee (2/4/2015)

---

Must do a first time import millions of rows into a table followed by a daily import of much less (just the differentials since day before) after that. ...

Mike49 (1/23/2015)

---

I'm sure this is a very newbie question, but I'm trying to understand the difference between accessing the Style Members below using approach 1 vs approach 2. In the...

skaggs.andrew (1/23/2015)

---

You are correct. That is weird. It's as if the records that are falling out are using the school_key as the school_year_key like the columns shifted or...

skaggs.andrew (1/23/2015)

---

Here is the constraint on my table:

ALTER TABLE [dbo].[APSB_FACT_SYK10] WITH NOCHECK ADD CONSTRAINT [CK_SCHOOL_YEAR_KEY_10] CHECK (([SCHOOL_YEAR_KEY]=(10)))

GO

ALTER TABLE [dbo].[APSB_FACT_SYK10] CHECK CONSTRAINT [CK_SCHOOL_YEAR_KEY_10]

GO

student_assessment_idassessment_idversion_idstudent_iddate_takenperformance_band_idpointspoints_possibleansweredpercent_correctnumber_of_questionsstudent_id_numSTUDENT_KEYSTUDENT_CURR_SCHOOL_IDSCHOOL_KEYSCHOOL_YEAR_KEYILL_ASSESSMENTS_KEYuser_idlocal_user_idlocal_user_id_charTEACHER_KEYILL_PERFORMANCE_BANDS_KEYILL_VERSIONS_KEYATT_CODE_KEYTERM_KEYTIME_KEYDISCIPLINE_KEYSTATE_TEST_KEYSTUDENT_ACTIVITY_KEYDIBELS_TEST_KEYDIBELS_CLASS_KEYHZ_EK_KEYHZ_STANDARD_KEYHZ_SUBJECT_COURSE_KEYHZ_TEST_KEYILL_REPORTING_GROUPS_KEYPERF_BAND_KEYPERIOD_KEYSECTION_COURSE_KEYErrorCodeErrorColumn

361040594058267162014-08-20 00:00:00.000450621.00000032.0000003265.6300003226716372733005271036864921782717827342880236974-9-9-9-9-9-9-9-9-9-9-9-9-9-9-9-9-10716076850

I already have several data...

skaggs.andrew (1/23/2015)

---

I checked all of the look-ups and what I am doing is redirecting records where there is no match to a derived column, giving it a value -9 and...

skaggs.andrew (1/23/2015)

---

Hi All,

I am running into an issue where I have created a data flow, source to target, with mainly just look-up transformations. When I execute the dataflow, it...

A few things I can think of or recommend:

1. What is your MaxInsertCommitSize set to?

2. If you are doing a select * from the source, then the source...

vick12 (10/24/2012)

---

Hi All,

I want to know if there is any automated tool which can be used to for post migration ETL testing? The ETL has been written using sql scripts...

Not...

robert.gerald.taylor (10/25/2012)

---

Charles,

But my situation is that I have 2008 R2 Standard edition on the production server, but when I open the production SSAS database directly through BIDS/VS I see partitions...

Excel needs unicode data. Insert a data conversion task between your source query and Excel destination, converting all fields to unicode. That should work...

I would start with one fact table at the highest level of granularity (features in your case). It will be easy enough to create a summarized fact table at the...

RenzoSQL (5/30/2012)

---

Hello Fellas,

I have a little question on what would be the best solution for the following scenario I am facing:

I have an ETL job that needs to run every...

eobiki10 (5/29/2012)

---

Hi All,

I have a date field from 01/08/2010 - 06/06/2011. In my report, I want this date to show as 2010 August or 2011 June respectively based on...