i
Infosys
Filter interviews by
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...
I applied via Company Website and was interviewed before Jan 2024. There was 1 interview round.
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
Infosys interview questions for designations
What people are saying about Infosys
I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
I am using Talend version 7.3.1 for ETL development.
I am currently using Talend version 7.3.1 for ETL development.
The specific version of Talend being used is 7.3.1.
Talend 7.3.1 offers various features and improvements for ETL processes.
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
I applied via Naukri.com and was interviewed before Apr 2023. There was 1 interview round.
based on 4 interviews
1 Interview rounds
based on 15 reviews
Rating in categories
Technology Analyst
55.3k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
51k
salaries
| ₹2.8 L/yr - ₹7.9 L/yr |
System Engineer
31.6k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
31k
salaries
| ₹5.1 L/yr - ₹19.6 L/yr |
Senior Associate Consultant
28.5k
salaries
| ₹6.2 L/yr - ₹17 L/yr |
TCS
Wipro
Cognizant
Accenture