Forum

Share:

Notifications

Clear all

Interview Questions & Answers

Here you will see all the Interview Questions and Answers related to Data Warehousing and ERD

Page 1 / 2 Next

Status

Topics

Replies

Views

Users

Date

What is slowly changing dimensions in data warehousing?

Topic Tags: slowlychangingdimensions, datawarehouseslowlychang,

2

531

<img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Deepika A" alt='' src='https://secure.gravatar.com/avatar/50a17564c6f838aa6a4dacc5df273ebe?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/50a17564c6f838aa6a4dacc5df273ebe?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 27, 20

Sep 27, 20

What is normalization in dbms?

Topic Tags: normalizationindbms, normalization,

1

487

<img alt="Vikky" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Vikky" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 17, 20

Sep 17, 20

What are the data cleansing steps?

Topic Tags: datacleansing, datacleaning,

1

300

<img alt="Vikky" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Vikky" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="VK" alt='' src='//www.gravatar.com/avatar/ac518374244fe639ba1bb54fb8b599de?s=24&r=g&d=mm' srcset='//www.gravatar.com/avatar/ac518374244fe639ba1bb54fb8b599de?s=24&r=g&d=mm 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 13, 20

Sep 13, 20

What is Star Schema and Snowflake Schema in Data Warehousing?

Topic Tags: differencebetweenstarsche, starschema, snowflakeschema,

2

388

<img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Siva Kumar" alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 03, 20

Sep 03, 20

What is Junk Dimension in Data Warehousing?

Topic Tags: junkdimension, useofjunkdimension, datawarehousejunkdimensi,

1

351

<img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

Aug 30, 20

Aug 30, 20

What are the types of fact table in data warehousing?

Topic Tags: typesoffacttables, datawarehousingfacttable, differenttypesoffacttabl,

1

347

<img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' data-src="https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="VK" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

Aug 30, 20

Aug 30, 20

Page 1 / 2 Next

Share: