Informatica concepts, Datawarehouse, SQL queries etc..
Informatica Developer Interview Questions
653 informatica 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?
Questions asked from various informatica Transformations- Stored procedure, Joiner, XML Phaser, Lookup.
Basic questions what you are applying for.
Calculate second maximum salary in Oracle
They asked me about my college project
Quais são sua experiência de trabalho
Basic dwh and informatica questions
Viewing 541 - 550 interview questions