Band 3 Interview Questions and Answers

Active and Passive transformation in Informatica and SQL query in a project

• Active transformation changes the number of rows that pass through it, while passive transformation does not

• Active transformation can change the data values, while passive transformation does not

• Examples of active transformation include Filter, Router, and Update Strategy, while passive transformation includes Expression and Sequence Generator

• SQL query in a project can be used to extract, manipulate, a...read more

To delete duplicate records in SQL, use the DISTINCT keyword or GROUP BY clause.

• Use the DISTINCT keyword to select unique records and delete the duplicates.

• Use the GROUP BY clause to group records by a specific column and delete duplicates within each group.

• Use the HAVING clause to filter out groups with more than one record.

• Example: DELETE FROM table_name WHERE column_name NOT IN (SELECT MIN(column_name) FROM table_name GROUP BY duplicate_column);