Infosys ETL Developer Interview Questions, Process, and Tips

Loads in Informatica refer to the process of moving data from source to target in a data warehouse.

• Loads involve extracting data from source systems

• Transforming the data as needed

• Loading the data into the target data warehouse or database

• Loads can be full, incremental, or delta depending on the requirements

• Example: Loading customer data from a CRM system into a data warehouse for analysis

Use GROUP BY and HAVING clause to find duplicates in a table.

• Use GROUP BY to group rows with same values together

• Use HAVING COUNT(*) > 1 to filter out duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.

• Optimize data flow by using efficient data sources and destinations

• Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations

• Increase parallelism by using multiple threads and optimizing task execution order

• Use performance monitoring tools like SSIS logging and performance counters...read more

Use a script to find and delete files older than 30 days.

• Use a script to identify files older than 30 days based on their creation or modification date

• Utilize a command like find or PowerShell to search for files older than 30 days

• Combine the script with a delete command to remove the identified files