Here is the list of Informatica Scenario based Interview Questions for Experienced, informatica faq with answers, informatica scenarios for practice, informatica real time scenarios with answers, informatica complex scenarios with answers, informatica scenario based questions on flat files, informatica scenarios for beginners.
- Design a scenario (get data from source through a flat file), look the source data in another flat-file/relational table and write in to target, what approach you will use.
- If there are more than 10 source files to be used in a mapping how will implement the same in Informatica?
- A file/table has only one column with values a,b,c,d,e. We need one row in the target with values a,b,c,d,e.How can this be implemented in informatica? How will you implement the reverse of the same scenario?
- A reusable session if being used across 5 workflows. If the session property needs to changed in one of the workflows, how will it be done?
- Find 3rd highest salary from EMP table from each department (Informatica) ?