Forum

Share:

Notifications

Clear all

Interview Questions & Answers

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

Status

Topics

Replies

Views

Users

Date

What is slowly changing dimensions in data warehousing?

Topic Tags: slowlychangingdimensions , datawarehouseslowlychang ,

2

871

<img alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img 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' decoding='async'/>

Sep 27, 20

Sep 27, 20

What is normalization in dbms?

Topic Tags: normalizationindbms , normalization ,

1

816

<img alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' 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' decoding='async'/>

Sep 17, 20

Sep 17, 20

What are the data cleansing steps?

Topic Tags: datacleansing , datacleaning ,

1

453

<img alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img 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' decoding='async'/>

Sep 13, 20

Sep 13, 20

What is Star Schema and Snowflake Schema in Data Warehousing?

Topic Tags: differencebetweenstarsche , starschema , snowflakeschema ,

2

595

<img alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img 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' decoding='async'/>

Sep 03, 20

Sep 03, 20

What is Junk Dimension in Data Warehousing?

Topic Tags: junkdimension , useofjunkdimension , datawarehousejunkdimensi ,

1

497

<img alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' 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' decoding='async'/>

Aug 30, 20

Aug 30, 20

What are the types of fact table in data warehousing?

Topic Tags: typesoffacttables , datawarehousingfacttable , differenttypesoffacttabl ,

1

478

<img alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' 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' decoding='async'/>

Aug 30, 20

Aug 30, 20

What is the OLTP and OLAP in Data Warehousing?

Topic Tags: oltp , olap , olapdatawarehouse , oltpdatabase , differencebetweenoltpand ,

1

370

<img alt='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' data-srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' height='40' width='40' decoding='async' 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='' 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' decoding='async'/>

<img alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' decoding='async' 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='' 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' decoding='async'/>

Aug 30, 20

Aug 30, 20

Share:

Forum Statistics

10 Forums

174 Topics

321 Posts

0 Online

1,386 Members

Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 2.2.2