Filter interviews by
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
A mapplet is a reusable object in Informatica PowerCenter that contains a set of transformations.
Mapplets can be used in multiple mappings to perform the same set of transformations.
They can simplify mapping development by encapsulating common logic.
Mapplets can have input and output ports to connect with other transformations.
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
Hive is used for managing and querying large datasets stored in Hadoop Distributed File System (HDFS).
It provides a SQL-like interface called HiveQL for querying data.
Hive organizes data into tables, partitions, and buckets to optimize queries.
It supports custom MapReduce scripts for complex data process...
Look up is used to retrieve data from a single source, while joiner is used to combine data from multiple sources.
Look up is used to search for a value in a data source and return a corresponding value from the same row.
Joiner is used to combine data from two or more sources based on a common key.
Look up is used for one-to-one mapping, while joiner is used for many-to-one or one-to-many mapping.
SCD2 logic in Informatica is used to track historical changes in data by creating new records for each change.
SCD2 stands for Slowly Changing Dimension Type 2
It involves creating new records for each change in data, while maintaining a link to the previous record
It typically includes effective start and end dates to track the validity of each record
SCD2 logic is commonly used in data warehousing to maintain historical
Router transformation sends data to multiple targets based on conditions, while filter transformation filters rows based on conditions.
Router transformation can send data to multiple targets based on conditions
Filter transformation filters rows based on conditions
Router transformation can be used to route data to different tables based on certain criteria
Filter transformation can be used to remove unwanted rows from th
posted on 9 Oct 2021
I applied via Campus Placement and was interviewed before Oct 2020. There was 1 interview round.
posted on 13 Sep 2021
I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.
posted on 12 Nov 2021
posted on 8 Mar 2022
posted on 12 Apr 2022
Bean life cycle refers to the stages a Java bean goes through from creation to destruction.
Bean is instantiated using a constructor or a factory method
Bean properties are set using setters or dependency injection
Bean is initialized using the init method
Bean can be used for its intended purpose
Bean is destroyed using the destroy method
posted on 24 Mar 2021
I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.
IT WAS BASIC AND EASY TO SOLVE
OOPS concepts in Java refer to the principles of Object-Oriented Programming such as inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class. Example: class B extends class A.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.
Polymorphism...
SQL data types and prime number logic code
SQL data types include integer, float, varchar, etc.
To write prime number logic in SQL, use a loop to check if a number is divisible by any number less than itself
Example: DECLARE @num INT = 7; SELECT CASE WHEN COUNT(*) = 2 THEN 'Prime' ELSE 'Not Prime' END FROM (SELECT 1 AS num UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) AS n
posted on 19 Jun 2022
I applied via Job Portal
Singleton pattern can be broken using reflection, serialization, and cloning.
Reflection can be used to access the private constructor and create multiple instances.
Serialization can create multiple instances when the object is deserialized.
Cloning can create a new instance of the singleton object.
based on 1 interview
Interview experience
Software Engineer
9
salaries
| ₹2.5 L/yr - ₹9 L/yr |
Software Developer
9
salaries
| ₹3 L/yr - ₹6 L/yr |
System Engineer
9
salaries
| ₹4 L/yr - ₹8.5 L/yr |
Software Development Engineer
8
salaries
| ₹11 L/yr - ₹30 L/yr |
Senior Software Engineer
7
salaries
| ₹4.8 L/yr - ₹12.3 L/yr |
Megha Engineering & Infrastructures
Shapoorji Pallonji Group
Alstom Transportation
Tata Technologies