Interested to Buy Any Domain ? << Click Here >> for more details...
Total Questions Posted # 0
Total Answers Posted # 3
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 46
Users Marked my Answers as Wrong # 50
Total Answers Posted # 3
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 46
Users Marked my Answers as Wrong # 50
Questions / { vignesh muralidharan }
Questions
Answers
Category
Views
Company
eMail
Answers / { vignesh muralidharan }
Question { ITC Infotech, 86666 }
What are the different types of schemas?
Answer
schema & snow flake schema.
Star schema:It is highly denormalised,so we can retrieve
the data very fast.
Star flake schema:Only one dimension contain one level of
hierachy key.
Snow flake schema:It is highly normalised,so retrievel of
data is slow.
| Is This Answer Correct ? | 34 Yes | 43 No |
Question { 6059 }
scd methodology?
Answer
are made the old data will be deleted and the new data will
be insrted.
Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.
Version:The changes made will be numbered as 0,1,2...so on.
Date:The changes along with the date in which they are made
are clearly mentioned.
Type3:The latest change which is made is alone available.
| Is This Answer Correct ? | 0 Yes | 0 No |
Question { 17490 }
what is scd?
Answer
through the slowly changing dimension process.There are
three types in slowly changing dimensions:
type1,type2.type3.
| Is This Answer Correct ? | 12 Yes | 7 No |
