Informatica concepts, Datawarehouse, SQL queries etc..
Informatica Etl Developer Interview Questions
208 informatica etl developer 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.
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
What is ETL? Complex Mapping? Performance Tuning. Push down optimization query? Sequence Generator?
Basic questions what you are applying for.
Calculate second maximum salary in Oracle
They asked me about my college project
Basic dwh and informatica questions
Customization in Informatica pi wth java. Avos workflows, step workflows
Informatica basics
Viewing 161 - 170 interview questions