Capgemini SQL and MSBI Developer Interview Questions and Answers

Q1. How can you segregate data from one file to many file based on data value of a particular column.
Ans. 
Use SQL queries to filter data based on a particular column value and export to separate files.
• Use SELECT statement with WHERE clause to filter data based on the particular column value

• Use INSERT INTO statement to insert the filtered data into separate tables or files

• Consider using a loop or cursor to iterate through the data and export to multiple files
Answered by AI
Add your answer
Q2. How to access multiple data file place in same directory.
Ans. 
To access multiple data files in the same directory, use a wildcard character (*) in the file path.
• Use a wildcard character (*) in the file path to access all files in the directory.

• For example, to access all CSV files in a directory, use 'SELECT * FROM folder_path/*.csv'.

• Make sure the SQL query or MSBI package is configured to handle multiple files.
Answered by AI
Add your answer
Q3. How to delete data if there is no primary key while there are repeated data sets
Ans. 
You can delete data without a primary key by using a combination of columns to identify and remove duplicate records.
• Identify unique combination of columns to differentiate between duplicate records

• Use the identified columns in a DELETE statement to remove duplicate records

• Consider using temporary tables or CTEs to handle the deletion process efficiently
Answered by AI
Add your answer

Scenario based questions

Q1. Why you want to join Capgemini?
Add your answer
Q2. What makes you confident that Capgemini will offer you?
Add your answer