Question
Calculate the largest 5-digit number which is divisible by
‘64’Solution
ATQ,
The largest 5-digit number = 99999
Since, 99999 ÷ 64 = 1562 × 64 + 31
So, Desired number = 1562 × 64 = 99968
ETL stands for:
Fact constellation schema is best described as:
What is the primary function of ETL in a data warehouse environment?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
A snowflake schema differs from a star schema mainly because:
Which of the following is NOT a common OLAP operation?
Data cleansing is primarily concerned with:
In ETL pipelines, which step is primarily responsible for resolving inconsistencies and correcting data quality issues (e.g., missing values, inconsiste...
What is the main purpose of a data mart?
Which of the following best describes a Data Warehouse?
