IT Professionals

[PARAMASHIVAN]

Hi Paramashivan,
A datawarehouse/data mart contain fact and dimension tables. I am attaching couple of documents which explains fact and dimension tables. The document has sample fact and dimension tables. It also has an image describing Fact and Dimension table relationship. This should give you a good starting point.

Fact and dimension tables are usually populated through Stored procedures/SSIS packages with the source data coming form OLTP relational systems. The SP's and SSIS denormalise the data and populate the fact and dimension tables. Usually the databases for a datawarehouse would be on a different server. The SSIS package would grab data from different source tables in OLTP transfer it to staging tables on datawarehouse database. From the satging tables Stored procedures would transform the data into denormalise form and load them into fact and dimension tables.

Fact Table:
A key characteristic of a fact table is that it contains numerical data (facts) that can be summarized to provide information about the history of the operation of the organization. Each fact table also includes a multipart index that contains as foreign keys the primary keys of related dimension tables, which contain the attributes of the fact records.

Also if you could give me you e-mail id we can correspond better for explanation of concepts.

On a lighter note : Rajini fan / kamal fan/?

Many thanks , I just re called the Staging database stuff, I have used SSAS before, but not much. I am PMing you my email ID

On a Lighter Note, I have a huge Fan list
Shivaji +SPB +Rajni >Kamal +KJY+TMS+PJ+PBS+PS+SJ+KSC +Raghuvaran>Karthik Heroine lis is bigger , So I wont post here

[ramdas2005]

Hi paramashivan,
What is PMing, is it the e-Mail set in my profile or Instant Messaging...
Thank you

[PARAMASHIVAN]

Ramdas

I meant Private Message

[ramdas2005]

Hi Raghu,
Thanks for the e-mail, sent my e-mail id.

[PARAMASHIVAN]

Hi all

Has anyone used inserted and deleted tables in SQL, regarding triggers.

[kirukan]

Yes Param...

[PARAMASHIVAN]

Thanks Kirukun, I managed to resolve the matter

[19thmay]

Hi,

I have a question.

How to select (SQL) all the values (numbers) in the table which has 3 digit after decimal point.

For example say A is the table it has following values

200.24
300.456
123.22
1234.344

From this I need only

300.456
1234.344

[app_engine]

19thmay,
What about doing a to_char and check for the fourth char starting from '.' (as to whether null)...just loud thinking...

[PARAMASHIVAN]

Hi All

I am trying to do this in SQL

Select 1 / 2 as [answer]

The result I get is 0

I tried the cast function as follows

select cast((1)/(2) as decimal (10,2)) as [answer]

it is still not giving me a decimal result of 0.5, what should I do ?