Exusia Interview Questions and Answers

Q1. Difference between OLAP, OLTP systems
Ans. 
OLAP is for analyzing data, OLTP is for transaction processing.
• OLAP stands for Online Analytical Processing, used for complex queries and data analysis.

• OLTP stands for Online Transaction Processing, used for routine transactions like insert, update, delete.

• OLAP systems are designed for read-heavy workloads, while OLTP systems are designed for write-heavy workloads.

• OLAP systems typically have a denormalized schema for f...read more
Answered by AI
Add your answer
Q2. Difference between star and snowflake schema
Ans. 
Star schema has a single centralized fact table with denormalized dimensions, while snowflake schema has normalized dimensions with multiple related tables.
• Star schema is easier to understand and query due to denormalized structure.

• Snowflake schema saves storage space by normalizing dimensions into separate tables.

• Star schema is more suitable for data warehousing and reporting purposes.

• Snowflake schema is more normaliz...read more
Answered by AI
Add your answer

Q1. Difference between Lookup and join, where we should use which one in Ab Initio.
Ans. 
Lookup retrieves data from a reference dataset, while join combines datasets based on a common key.
• Lookup is used for fetching a single value or a small set of values from a reference dataset.

• Join combines two datasets based on a common key, producing a new dataset with combined records.

• Use Lookup when you need to enrich data with additional attributes from a reference table.

• Use Join when you need to merge two datasets...read more
Answered by AI
Add your answer
Q2. Ab Initio Scenerio Based questions.
Add your answer
Q3. Delete files with 0KB size from a directory. (Unix)
Ans. 
Use find command to locate files with 0KB size and delete them using the rm command.
• Use find command with -size 0 option to locate files with 0KB size in a directory

• Pipe the output of find command to rm command to delete the files

• Example: find /path/to/directory -type f -size 0 -exec rm {} \;
Answered by AI
Add your answer
Q4. Delete 10 days older files. (unix)
Ans. 
Use find command with -mtime option to delete files older than 10 days.
• Use find command with -mtime option to search for files older than 10 days.

• Combine find command with -delete option to delete the files found.
Answered by AI
Add your answer
Q5. Get the second highest salary. (SQL)
Add your answer

Q1. Ab initio scenerio based questions. Question on the project.
Add your answer
Q2. Questions based on different components like Roll up, scan, reformat, join, etc. (Ab Initio)
Add your answer
Q3. Questions based on sed, awk, and grep commands. (UNIX)
Add your answer
Q4. Questions on Window function. (SQL)
Add your answer

Q1. In-depth discussion on project. Components used there and the process of the graph.
Add your answer
Q2. Questions on Continuous Flow, conduct>IT.
Add your answer
Q3. Full working of different partition components, multifiles, checkpoints and phases.
Ans. 
Partition components, multifiles, checkpoints, and phases in data processing.
• Partition components refer to dividing data into smaller chunks for processing efficiency.

• Multifiles are multiple files used to store data during processing.

• Checkpoints are markers set during processing to save progress and enable restart from a specific point.

• Phases represent different stages of data processing workflow.

• Example: In a MapReduc...read more
Answered by AI
Add your answer
Q4. Why not to use lookup for join, where we can not use join. Disadvantage of using sort component.
Ans. 
Using lookup for join can be inefficient and lead to performance issues. Sort component can be slow and resource-intensive.
• Lookup for join can be inefficient for large datasets as it requires scanning the entire dataset for each lookup value.

• Join is more optimized for joining datasets based on a common key, while lookup is better suited for smaller reference tables.

• Sort component can be slow and resource-intensive, esp...read more
Answered by AI
Add your answer

Q1. Why you want to join Exusia. Reason for the job change.
Add your answer
Q2. Salary expectations and document submission.
Add your answer

Q1. Abinito components usage
Ans. 
Abinito components are used in ETL processes for data integration and transformation.
• Abinito components are used in ETL (Extract, Transform, Load) processes for data integration and transformation.

• Some commonly used Abinito components include Input Table, Output Table, Join, Partition, Sort, Filter, and Lookup.

• Abinito provides a graphical interface for designing ETL processes using these components.

• Abinito components c...read more
Answered by AI
Add your answer
Q2. Air commands and Multi file system
Add your answer

Q1. Project related details and questions
Add your answer
Q2. Experience related to background
Add your answer

Q1. Salary expectations
Add your answer

Python coding, and sql

Q1. Spark, python, sql
Add your answer
Q2. Spark architechture
Add your answer
Q3. Python rcoding question
Add your answer