EXL Service Assistant Consulting Manager Interview Questions, Process, and Tips

Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN...read more

All returns all values in a table, while Allexcept returns all values except those specified in the argument.

• All returns all values in a column or table.

• Allexcept returns all values in a column or table except those specified in the argument.

• Example: All(Table[Column]) returns all values in the specified column.

• Example: Allexcept(Table, Table[Column]) returns all values in the table except those in the specified column

Append adds new data to the end of a dataset, while merge combines two datasets based on a common key.

• Append adds rows to the end of a dataset, while merge combines rows from two datasets based on a common key column.

• Append is useful for adding new observations to an existing dataset, while merge is used to combine datasets with related information.

• Append does not require a common key, while merge requires a common key...read more

Data Gateways are software or hardware solutions that enable secure and efficient transfer of data between different systems or networks.

• Data Gateways act as intermediaries between data sources and data destinations

• They help in translating data formats, protocols, and security measures to ensure smooth data transfer

• Examples include Amazon API Gateway, Microsoft Azure Data Gateway, and IBM DataPower Gateway

Dynamic Row filter is a feature that allows users to filter rows in a table based on certain criteria that can change dynamically.

• Dynamic Row filter allows users to specify conditions for filtering rows in a table.

• Users can set up dynamic filters that change based on user input or other factors.

• For example, a dynamic row filter could be set up to only show rows where the value in a certain column is greater than a user