INTERVIEW QUESTIONS DATA WAREHOUSING DATA WAREHOUSING CONCEPTS DETAILS

Question: explain in detail about
type 1,
type 2(SCD),
type 3 ?

Answer: Type-1

Most Recent Value

Type-2(full History)

i) Version Number

ii) Flag

iii) Date

Type-3

Current and one Perivies value

Type-1

Most Recent Value

Type-2(full History)

i) Version Number

ii) Flag

iii) Date

Type-3

Current and one Perivies value
Source: CoolInterview.com

SCD'S slow change dimension

there are three types
scd1, scd2, scd3

scd1:- suppose it the data got updated in the table then there r 2 methods one is to drop the table and upload the new one. but its along process.
here by using table compression we can update the particular data that has been modified. that is scd1

scd2:- by using key generation we r going to generate the new rownum column if there r any update the next row will be updated one and row numbers will be increamented automatically by 1

scd3:- i this one a extra column is added and updated infromation is stored in that column. if again table is update another column is added to it again...

in this one scd2 is mostly used.. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question