Can you write sample BTEQ to load data from source to target..
Informatica Developer Interview Questions
294 informatica developer interview questions shared by candidates
List active and passive transformations?
Informatica without using Router, Filter, Expression, Seq gen, ranker, variables, update strategy load the target table with RDBMs source data having employees data having eids starting from 1-100 in two different targets by one having divisible by 5 and another with the rest
Skill related questions
unix commands and how to fetch header of file , and how to display date of some employee only month how to display
Are you willing to work on open source ETL tools ? We are not planning to use Informatica in near future.
They ask scenario based questions on Informatica and SQL
they asked me like how many types lookup transformation in Informatica.
1.)what is the passive transformation? 2.)What is the indirect file loading? 3.)what is the lookup transformation? 4.)How to retrive the top nth salary(means 2nd highest or 3rd highest salary) in Oracle:
Most of them were on SQL
Viewing 21 - 30 interview questions