i
Exusia
Filter interviews by
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...
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...
Rate your
company
🤫 100% anonymous
How was your last interview experience?
I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.
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 {} \;
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.
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...
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...
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...
I was interviewed in Oct 2024.
Python coding, and sql
Exusia interview questions for popular designations
Data profiling is the process of analyzing and summarizing data to gain insights into its quality, structure, and content.
Data profiling involves examining data to understand its characteristics, such as data types, patterns, and relationships.
It helps in identifying data quality issues, such as missing values, outliers, and inconsistencies.
Data profiling can also reveal data distribution, frequency of values, and data...
Data modeling is the process of creating a visual representation of data structures and relationships to help understand and analyze data.
Data modeling helps in organizing and structuring data in a way that is easy to understand and analyze.
It helps in identifying relationships between different data elements.
Data modeling is important for designing databases, developing data warehouses, and improving data quality.
Exam...
I was interviewed in Sep 2024.
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 3 interview rounds.
I handle tasks by breaking them down into smaller steps, setting priorities, and utilizing time management techniques.
Break down the task into smaller steps
Set priorities based on deadlines and importance
Utilize time management techniques such as Pomodoro method or Eisenhower matrix
I was interviewed in Feb 2024.
UNIX concepts , express it , some data warehousing question
Top trending discussions
based on 15 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 222 reviews
Rating in categories
Senior Consultant
118
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
105
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
84
salaries
| ₹0 L/yr - ₹0 L/yr |
Management Consultant
69
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics