sowmi


{ City } chennai
< Country > india
* Profession *
User No # 83827
Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 1
Total Views for My Questions # 3333

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 29
Questions / { sowmi }
Questions Answers Category Views Company eMail

not able to connect to SBI Visa payment server...Getting message like "Server not found"...."proxy protected by firewall"....how to resolve this issue?

TCS,

1 Networking AllOther 3333



Answers / { sowmi }

Question { 16081 }

DWH architecture?


Answer

DWH Architecture:

It has 3 layers:

1.Staging
2.Integration
3.Target

In staging we get the raw data.In integration we process i.e
we cleanse the data.In target the data is ready to be used
by end users for report generation.

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 17138 }

Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?


Answer

scd 1:It wont implement the new change.It always contains
the historic data alone.
scd 2:It will replace or overwrite the existing record.It
will not contain the historic data.But it has surrogate key.
scd 3:It contains both the old data and a new record with
the modified information and has additional columns like
"effective start date and end date" or "version no".

Please correct me if i am wrong

Is This Answer Correct ?    0 Yes 20 No


Question { Polaris, 8912 }

What is conformed dimension?


Answer

conformed dimension is one type of dimension tables and it
contains the same row as present in fact table

Is This Answer Correct ?    0 Yes 9 No