Tmte Metal Tech Interview Questions and Answers

Both have their own advantages and disadvantages depending on the use case.

• Star schema is simpler and easier to understand, but may not be suitable for complex data relationships.

• Snowflake schema is more normalized and can handle complex data relationships, but can be more difficult to understand and maintain.

• The choice between the two depends on the specific requirements of the project and the data being analyzed.

• For example, a data warehouse for a retail company may benefit...read more

Datatype consistency in minus query

• Datatype of selected columns should remain same for minus query

• Mismatch can cause errors or unexpected results

Implemented Opps concept in framework for efficient test automation

• Used Object-Oriented Programming principles to create reusable test components

• Utilized Page Object Model design pattern to separate test logic from page elements

• Implemented Inheritance and Polymorphism for code reusability and maintainability

Database stores data for applications, data warehouse stores data for analysis.

• Database is used for transactional processing, data warehouse is used for analytical processing.

• Database stores current data, data warehouse stores historical data.

• Database is optimized for read and write operations, data warehouse is optimized for read operations.

• Examples of databases include MySQL, Oracle, and SQL Server. Examples of data warehouses include Amazon Redshift and Google BigQuery.

Cast function is used to change the datatype of a value or expression in SQL.

• Syntax: CAST(expression AS datatype)

• Example: CAST('123' AS INT) will convert the string '123' to integer datatype

• Supported datatypes: INT, FLOAT, DECIMAL, CHAR, VARCHAR, DATE, TIME, etc.

Pyramid program in C language

• Use nested loops to print the pyramid pattern

• The number of rows in the pyramid can be taken as input from the user

• Example: for a pyramid with 5 rows, the pattern would be: * *** ***** ******* *********