Biodeal Pharmaceuticals Limited Quality Analyst Interview Questions and Answers

SCD refers to Slowly Changing Dimensions in data warehousing, managing changes in data over time.

• Type 0: Passive - No changes are made to the existing data. Example: Historical data remains unchanged.

• Type 1: Overwrite - Old data is replaced with new data. Example: Correcting a misspelled name.

• Type 2: Add New Row - A new record is created for changes, preserving history. Example: Tracking changes in customer addresses.

• T...read more

SQL joins combine rows from two or more tables based on related columns.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left ...read more

MDM stands for Master Data Management, a process for managing critical data across an organization.

• Ensures consistency and accuracy of key business data across systems.

• Involves data governance, data quality, and data integration.

• Examples include managing customer, product, and supplier data.

• Helps in decision-making by providing a single source of truth.