Home Credit Finance Risk Management Specialist Interview Questions and Answers

Joins in SQL 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 le...read more

Yes, I'm familiar with M-code, which is used for data transformation in Power BI's Power Query.

• M-code is a functional language used in Power Query for data manipulation.

• It allows users to create custom queries to transform data before loading it into Power BI.

• Example: You can use M-code to filter rows, change data types, or merge tables.

• M-code syntax includes functions like Table.SelectRows, Table.AddColumn, and Text.U