EdgeVerve Systems Product Integration Analyst Interview Questions and Answers

Window functions are used to perform calculations across a set of rows in a table, while analytical functions compute values based on a group of rows.

• Window functions include functions like ROW_NUMBER, RANK, and LAG.

• They are used to calculate running totals, moving averages, and cumulative sums.

• Analytical functions include functions like SUM, AVG, and COUNT.

• They are used to compute aggregate values within a group of ro

A table with foreign keys and primary keys is created to establish relationships between tables.

• Foreign keys are used to link a column in one table to the primary key of another table.

• Primary keys uniquely identify each record in a table.

• Foreign keys ensure referential integrity and maintain data consistency.

• Example: Creating a 'Orders' table with a foreign key 'customer_id' referencing the 'Customers' table's primary