@gpo, at least you made me feel a little better about my current situation after that story. It makes me wonder, how do you make an ignoramus like...

If I understand correctly, when looking at the same table with different clients, you can see the japanese characters in one, but not in the other? Doesn't that mean the...

Kimball books have a sample Insurance data warehouse. You might need to roll the scripts yourself though. I don't think there is much point relying on a sample data warehouse...

Does your client have a team of Oracle warlocks or SQL Server wizards on their team? There is no point convincing an Oracle shop that they should run on SQL...

Very Good point - what are the top questions.

Starting at question 1:

1. What training has each staff member done or need to do

This implies the following objects:

Some kind of Staff...

I don't understand enough about your technical issue with lookups, but for starters be aware that under default settings it is case sensitive.

You generally would not load a source system...

From your sample tables you don't really have a star schema. If possibly you should denormalise your dimension as much as posssible, not split them off into snowflakes

You need to...

@gpo I think you make some very good points - who peer reviewed this?

I think there is some value in the article but by no stretch of the...

Are you kidding me? someone posts into a discussion on forum etiquette asking a new question and breaking most of the rules of forum etiquette in the process!

Anyway.... I'm suprised...

MS Access does not have OPENQUERY or OPENROWSET. Those are SQL Server keywords.

This is a SQL Server/Oracle forum. You need to clarify whether you are talking about MS Access or...

As already suggested, the issue is because a column, table or alias name is longer than 30 characters, which is the Oracle size limit on object names.

It is nothing to...

Thanks for your advice Scott.

I did change the PK to

RowNum_Start,SRC_System, SRC_Application

and also

SRC_System, SRC_Application,RowNum_Start

(Yes I know you can create a clustered index that isn't based on the primary key)

In both cases...

We load end-of-day transaction files from multiple banks using the same package. We have multiple SQL Agent jobs and use the /config parameter to provide a different config file for...

I took an uneducated guess and

-Added a unique index to RowNum_Start

-Removed the SRC_System join (I know I know, changing the requirements is cheating )

and query time went from...

SQL Agent is tricky because:

1. If you have only one SQL Agent job being your 'host' you can't run mutliple jobs in parallel

2. If you want to have a non...