Databases | SQL | Oracle | MS Access Answers

channel_user table

 channel_id user_id      subscribed_datetime

 100       1      2020-12-10 10:30:45

 100       7      2020-10-10 11:30:45

channel_user table stores the data of the channel_ids and their subscribers' user_ids.

user_likes table

user_id  video_id reaction_type reacted_at

1   10       LIKE      2020-12-10 10:30:45

7   10       DISLIKE 2020-10-10 11:30:45

video_genre table

video_id genre_id

10      201

10     202

Get all the distinct user_ids who liked at least one video uploaded by Android Authority Channel (channel__id = 364) but didn't like the video uploaded by Tech savvy channel with video_id = 1005.

Consider reaction_type LIKE as liked

Sort the output in the ascending order of user_id.

Expected Output Format

 user_id

 ...

What are the two extremes for technical architecture design? Which one is

better?

Discuss the phases of warehouse architecture? 

Under what condition an operation can be executed in parallel?

What is mean by click stream? How it can be used in a web Data Warehouse environment

(a) What is data parallelism explain with example?

(b) Under what condition an operation can be executed in parallel?

You are a manager of Data Warehouse, how you keep the data validate in terms of secure data of validation?

Explain in detail the concept of modeling the Business Data Warehousing (BDW)?

You are a manager of Data Warehouse, how you keep the data validate in terms of secure data of validation?

What are the two extremes for technical architecture design? Which one is better?