Creating DDS Database StructureAfte

Creating DDS Database Structure
After we created the databases, we can now create the tables based on the logical design that
we created in the previous chapter. Let’s start with the DDS. It has five fact tables and fourteen
dimensions. Let’s do the Product Sales fact table first. We’ll do the four dimensions that it uses
first and then the fact table. We defined these four dimension tables in the previous chapter.
So, open SQL Server 2005 Management Studio, connect to your development SQL Server
instance, and start creating the tables. You can use Management Studio’s point-and-click functionality
if you want, or you can script it.
Either way, create the date dimension table as follows:

0/5000

Dari: -

Ke: -

Hasil (Bahasa Indonesia) 1: [Salinan]

Disalin!

Creating DDS Database StructureAfter we created the databases, we can now create the tables based on the logical design thatwe created in the previous chapter. Let’s start with the DDS. It has five fact tables and fourteendimensions. Let’s do the Product Sales fact table first. We’ll do the four dimensions that it usesfirst and then the fact table. We defined these four dimension tables in the previous chapter.So, open SQL Server 2005 Management Studio, connect to your development SQL Serverinstance, and start creating the tables. You can use Management Studio’s point-and-click functionalityif you want, or you can script it.Either way, create the date dimension table as follows:

Sedang diterjemahkan, harap tunggu..

Hasil (Bahasa Indonesia) 2:[Salinan]

Disalin!

Membuat DDS Struktur Database
Setelah kita buat database, kita sekarang dapat membuat tabel berdasarkan desain logis yang
kita buat dalam bab sebelumnya. Mari kita mulai dengan DDS. Ini memiliki lima tabel fakta dan empat belas
dimensi. Mari kita lakukan tabel fakta Penjualan Produk pertama. Kami akan melakukan empat dimensi yang menggunakan
pertama dan kemudian tabel fakta. Kami mendefinisikan empat tabel dimensi ini di bab sebelumnya.
Jadi, buka SQL Server 2005 Management Studio, terhubung ke Server SQL pengembangan Anda
misalnya, dan mulai membuat tabel. Dapat Anda gunakan Manajemen Studio point-and-klik fungsi
jika Anda ingin, atau Anda dapat script itu.
Either way, membuat tabel dimensi tanggal sebagai berikut:

Sedang diterjemahkan, harap tunggu..

Hasil (Bahasa Indonesia) 3:[Salinan]

Disalin!

Sedang diterjemahkan, harap tunggu..

Bahasa lainnya

Dukungan alat penerjemahan: Afrikans, Albania, Amhara, Arab, Armenia, Azerbaijan, Bahasa Indonesia, Basque, Belanda, Belarussia, Bengali, Bosnia, Bulgaria, Burma, Cebuano, Ceko, Chichewa, China, Cina Tradisional, Denmark, Deteksi bahasa, Esperanto, Estonia, Farsi, Finlandia, Frisia, Gaelig, Gaelik Skotlandia, Galisia, Georgia, Gujarati, Hausa, Hawaii, Hindi, Hmong, Ibrani, Igbo, Inggris, Islan, Italia, Jawa, Jepang, Jerman, Kannada, Katala, Kazak, Khmer, Kinyarwanda, Kirghiz, Klingon, Korea, Korsika, Kreol Haiti, Kroat, Kurdi, Laos, Latin, Latvia, Lituania, Luksemburg, Magyar, Makedonia, Malagasi, Malayalam, Malta, Maori, Marathi, Melayu, Mongol, Nepal, Norsk, Odia (Oriya), Pashto, Polandia, Portugis, Prancis, Punjabi, Rumania, Rusia, Samoa, Serb, Sesotho, Shona, Sindhi, Sinhala, Slovakia, Slovenia, Somali, Spanyol, Sunda, Swahili, Swensk, Tagalog, Tajik, Tamil, Tatar, Telugu, Thai, Turki, Turkmen, Ukraina, Urdu, Uyghur, Uzbek, Vietnam, Wales, Xhosa, Yiddi, Yoruba, Yunani, Zulu, Bahasa terjemahan.