Skip to contentSkip to footer

Informatica Analist Interview Questions

Salaries
Interviews

1,186 informatica analist interview questions shared by candidates

1. Source directory had N nbr of files. Use informatica and send to target filename and count of data of each file in that folder. 2. Delete dups in a table. SQL 3. Full form of GREP. 4. Flat file having string word in every line. For complete file, send count of each alphabet in target. Implement through Informatica.
avatar

Informatica Developer

Interviewed at Broadridge

3.7★
Jun 15, 2015

1. Source directory had N nbr of files. Use informatica and send to target filename and count of data of each file in that folder. 2. Delete dups in a table. SQL 3. Full form of GREP. 4. Flat file having string word in every line. For complete file, send count of each alphabet in target. Implement through Informatica.

Difference between synchronisation and replication task in IICS Lookup and why is it used Scd type 2 How to check why session or workflow failed? Types of files created by Informatica session Can we write lkp override for flat file? Sql to remove duplicate records Types of tasks in Informatica Stop and abort difference Types of constraints
avatar

Informatica ETL Developer

Interviewed at Cognizant

3.6★
May 19, 2021

Difference between synchronisation and replication task in IICS Lookup and why is it used Scd type 2 How to check why session or workflow failed? Types of files created by Informatica session Can we write lkp override for flat file? Sql to remove duplicate records Types of tasks in Informatica Stop and abort difference Types of constraints

Viewing 971 - 980 interview questions

Glassdoor has 1,186 interview questions and reports from Informatica analist interviews. Prepare for your interview. Get hired. Love your job.