MJB Technologies Data Analyst Interview Questions and Answers for Freshers

ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a data warehouse.

• Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, normalized, and transformed into a consistent format suitable for analysis.

• Load: The transformed data is loaded into a data warehouse or...read more

Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.

• Primary key ensures each record is unique

• Foreign key establishes a relationship between tables

• Primary key can be a single column or a combination of columns

• Foreign key references the primary key of another table