i
Cognizant
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in May 2022. There were 3 interview rounds.
Filter transformation is used to filter rows from a data source based on specified conditions.
Filter transformation is an active transformation in Informatica PowerCenter.
It allows you to define conditions to filter rows from the source data.
Rows that meet the filter conditions are passed to the next transformation, while others are dropped.
Filter transformation can be used to eliminate unwanted data or select specific...
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup receives input values directly from the pipeline, while unconnected lookup receives input values from the calling transformation.
Connected lookup returns a value to the pipeline, while unconnected ...
Active transformations change the number of rows that pass through it, while passive transformations do not.
Active transformations change the data stream by adding, deleting, or modifying rows
Passive transformations do not change the data stream, but may change the data within the stream
Active transformations include Filter, Router, Update Strategy, and Expression
Passive transformations include Aggregator, Joiner, Look
Pushdown automata is a type of automata that can recognize context-free languages.
Pushdown automata is a theoretical model of computation.
It has a stack that can be used to store and retrieve information.
It is used to recognize context-free languages.
It is more powerful than finite automata but less powerful than Turing machines.
Examples of context-free languages include arithmetic expressions and programming languages
Use SQL merge statement to update table without update strategy
Use SQL merge statement to update table
Specify the source and target tables
Define the join condition
Specify the columns to update
Use WHEN MATCHED THEN UPDATE statement
Use WHEN NOT MATCHED THEN INSERT statement
More on informatica and SQL code
I was interviewed in Apr 2021.
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.
Delete is a DML operation, while truncate and drop are DDL operations.
Delete is slower as it logs individual row deletions, while truncate and drop are faster.
Delete can be rolled back, while truncate and drop cannot be rolled back.
Delete can have conditions to specify which rows to delete, while truncate and drop af...
A SQL query to find duplicates in a table.
Use the GROUP BY clause to group the records by the columns that may have duplicates.
Use the HAVING clause to filter the groups that have more than one record.
Select the columns that you want to display in the result.
Order the result if necessary.
Union combines the result sets of two or more SELECT statements, while Union All combines all rows from two or more SELECT statements.
Union removes duplicate rows from the result set, while Union All does not.
Union requires the number and order of columns in all SELECT statements to be the same, while Union All does not have this requirement.
Union is slower than Union All because it performs a distinct operation, while...
An analytical syntax example is SELECT COUNT(*) FROM table_name;
Analytical syntax is used to retrieve and analyze data from databases
Commonly used in business intelligence and data warehousing
Other examples include GROUP BY, ORDER BY, and JOIN statements
posted on 14 May 2022
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.
I was interviewed before Sep 2020.
Round duration - 140 minutes
Round difficulty - Medium
Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...
Given two numbers represented as arrays, calculate their sum and return the result as an array.
Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros
Round duration - 20 minutes
Round difficulty - Easy
The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.
Round duration - 8 minutes
Round difficulty - Easy
This round was conducted right after finishing and clearing the technical round at the same place and on the same day.
Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.
Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
I applied via Job Portal and was interviewed before Apr 2021. There was 1 interview round.
Solid principles are a set of design principles for writing maintainable and scalable code in C#.
Single Responsibility Principle (SRP) - a class should have only one reason to change
Open/Closed Principle (OCP) - a class should be open for extension but closed for modification
Liskov Substitution Principle (LSP) - derived classes should be substitutable for their base classes
Interface Segregation Principle (ISP) - client...
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
based on 1 interview
Interview experience
based on 12 reviews
Rating in categories
Associate
72.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Programmer Analyst
55.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
48.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Processing Executive
28.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
17.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
Accenture