InfoObjects Interview Questions, Process, and Tips

Aptitude test was easy . It is all formula based

It was a pen-paper coding test in which we had to solve 2 questions out of 3 to enter into the next round.

It is a non-elimination round and the performance of both the coding and gd will take you forward to the technical round.

Q1. I was asked to introduce myself.
Add your answer
Q2. Project details in depth were asked.
Add your answer
Q3. Dbms concepts were asked like joins etc.
Add your answer

Q1. Difference between repartition and coalesc?
Ans. 
Repartition increases the number of partitions in a DataFrame, while coalesce reduces the number of partitions.
• Repartition involves shuffling data across the network and can be used to increase the parallelism of operations.

• Coalesce minimizes data movement by only creating new partitions if necessary.

• Repartition is typically used when there is a need for more parallelism, while coalesce is used to reduce the number of ...read more
Answered by AI
Add your answer
Q2. About my project
Add your answer

Q1. SQL question based on joins, aggregation
Add your answer
Q2. Write SQL query for getting highest employee salary
Ans. 
SQL query to retrieve the highest employee salary
• Use the SELECT statement to retrieve the maximum salary from the employee table

• Use the MAX() function to find the highest salary value

• Combine the MAX() function with the SELECT statement to get the desired result
Answered by AI
Add your answer