Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the best way of processing millions of records into FACTS and Dimension?

Status
Not open for further replies.
Motlatjo

Motlatjo

Programmer
Oct 11, 2011
76
ZA
Hi

I am creating a data warehouse that is sourcing millions of records.

I am using Slow Changing dimension and TSQL views to process the Dimensions and FACTs

Now performance is very bad

How can i make it better?

Thank you in advance

 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
220
fredericofonseca
fredericofonseca
Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
286
Cpreston
Cpreston
arunaramana
  • Locked
  • Question
what are the items in a collection that referred in foreach item type enumerator within foreach loop
Replies
1
Views
211
Igelchen
Igelchen
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
161
arunaramana
arunaramana
appelq
  • Locked
  • Question
SSIS import from CSV is truncating the Decimal 1
Replies
2
Views
306
appelq
appelq

Part and Inventory Search

Sponsor

Back
Top