KoldCoffee (2/4/2015)

---

OK, hi nevyn, jeff, martin.

Answers:

There are 14 files daily which translates to 14 tables. I will give numbers for the three biggest tables (settings_dimension/keyword/group).

How many rows...

cstg85 (2/4/2015)

---

I typically like to have a separate staging database, because you really don't need a backup of the data...only the ddl of your staging tables are important to...

cstg85 (2/4/2015)

---

Nevyn,

The column names will not change, I will read that Stairways article and give it a shot, thank you for the link. I guess my first thought was to...

My recommendation would be to stage the data on Server 2. It would then be very easy to execute a merge (or insert/update) statement on your target table. You can...

I'll add one more question, if I may 🙂

Are you using the merge component in SSIS (I hope not), or a merge statement in T-SQL?

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...