20+ Dabur Interview Questions and Answers

Bookmarks in Power BI are a way to save the current view of a report and return to it later.

• Bookmarks capture the current state of visuals, filters, and slicers in a report.

• They can be used to create custom navigation experiences for users.

• Bookmarks can also be used to create interactive storytelling experiences.

• They can be accessed and managed through the Bookmarks pane in Power BI Desktop.

• Bookmarks can be exported and imported between reports.

Storage mode in Power BI determines how data is stored and processed in memory.

• There are two storage modes in Power BI: Import and DirectQuery.

• Import mode loads data into Power BI's internal memory for faster processing.

• DirectQuery mode connects to the data source in real-time and queries the data on demand.

• Import mode is recommended for smaller datasets, while DirectQuery is better for larger datasets.

• Choosing the right storage mode depends on the size and complexity of the ...read more

Calculate function is used to create new calculated columns or measures in Power BI.

• Allows users to create custom calculations based on existing data

• Can be used to create new columns or measures

• Syntax: CALCULATE(, )

• Example: CALCULATE(SUM(Sales[Revenue]), FILTER(Sales, Sales[Year] = 2021))

Parameters in Power BI are user-defined values that can be used to filter data in reports and dashboards.

• Parameters allow users to interact with the report and customize the data they see.

• They can be used to filter data, set default values, and control the behavior of visuals.

• Parameters can be created for various data types, such as text, numbers, dates, and lists.

• They can also be used in DAX expressions to create dynamic calculations.

• Examples of parameters include date range...read more

Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.

• Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

• Use regular expressions and pattern matching to validate data formats

• Write custom scripts to perform more complex data validation tasks

• Perform data profiling to identify potential data quality issues

• Use data quality tools like Apache Nifi or Talend to automate data...read more

Create a CRUD app to render, edit, delete, and sort a list of objects in a table.

• Create a React component to render a table with data from the array of objects.

• Implement functions for editing and deleting objects from the list.

• Add functionality to sort the list based on object properties.

• Use state and props to manage data and re-render the table when changes occur.

Join two tables in PySpark code and DataFrame

• Create two DataFrames from the tables

• Specify the join condition using join() function

• Select the columns to be displayed using select() function

• Use show() function to display the result

Current project involves MDM implementation with match rules and canonical values. Faced integration challenges and implemented fall back strategy.

• Types of match rules include exact match, fuzzy match, phonetic match, etc.

• Integration challenge was with data mapping and transformation between systems.

• Fall back strategy involved using default values or manual intervention in case of errors.

• Canonical value in RDM refers to the standardized value used across systems for a particu...read more

rem, em, px are units of measurement in CSS. React hooks like useEffect replace lifecycle methods for side effects.

• rem: relative to the font-size of the root element (html). Example: 1rem = 16px

• em: relative to the font-size of the element. Example: 2em = 32px if font-size is 16px

• px: fixed-size units. Example: font-size: 16px

• useEffect: replaces componentDidMount, componentDidUpdate, and componentWillUnmount in class components

• Hooks are used for state management and side effect...read more

Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities.

• Power BI is a cloud-based service that allows users to connect, analyze, and visualize data from a variety of sources

• It offers a range of data visualization tools, including charts, graphs, and maps

• Power BI also includes natural language processing capabilities, allowing users to ask questions and receive answers in plain English

• Users can creat...read more

Developed a web application for tracking personal fitness goals and progress.

• Used React.js for front-end development

• Implemented RESTful APIs for data retrieval and storage

• Utilized MongoDB for database management

Yes, faced challenges with debugging complex code and integrating third-party APIs.

• Debugging complex code with multiple dependencies

• Integrating third-party APIs with inconsistent documentation

• Resolving compatibility issues between different software components

Listen actively, identify the root cause, and collaborate on a solution.

• Listen to their concerns and acknowledge their perspective.

• Identify the root cause of the conflict and address it directly.

• Collaborate on a solution that meets both parties' needs.

• Maintain a professional and respectful demeanor throughout the process.

• Involve a neutral third party if necessary.

Count occurrences of a letter in a string.

• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.

Raw data can come from various sources, including internal databases, external sources, and user-generated content.

• Internal databases such as customer relationship management systems

• External sources such as government databases or social media platforms

• User-generated content such as online reviews or survey responses

Fibonacci series can be generated in Informatica using a recursive function.

• Create a mapping with a recursive function

• Use a variable port to store the previous two values

• Use an expression transformation to generate the series

• Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)

Agile emphasizes working software over comprehensive documentation, so reports are limited to those that support the team's work.

• Agile reports are focused on progress and performance

• Common reports include burndown charts, velocity charts, and cumulative flow diagrams

• Reports should be simple, easy to understand, and actionable

• Reports should be used to facilitate communication and collaboration within the team

• Reports should be adapted to the needs of the team and the project

Complex SQL scenarios and their results

• Using subqueries to filter data

• Joining multiple tables with complex conditions

• Using window functions to calculate running totals

• Pivoting data to transform rows into columns

• Using recursive queries to traverse hierarchical data

Performance optimization techniques for React JS frontend development

• Use React.memo for optimizing functional components

• Avoid unnecessary re-renders by using shouldComponentUpdate or PureComponent for class components

• Implement code splitting to reduce initial load time

• Use lazy loading for components that are not immediately needed

• Optimize images and assets for faster loading times

• Minimize the use of inline styles and use CSS for styling

• Avoid unnecessary state updates by using...read more

Real-time project scenario involves monitoring and controlling processes as they happen, ensuring timely responses and adjustments.

• Real-time data collection and analysis

• Immediate feedback and decision-making

• Continuous monitoring and optimization

• Examples: real-time monitoring of manufacturing processes, real-time traffic management systems