Here are the ETL Informatica interview questions asked in CGI.
CGI Interview Questions
Q.1) What kind of testing you people will do?
A1) Unit testing, System testing, and Integration testing
Q.2) What is Push down performance in informatica?
A2) It pushes activities of source on the target database, instead of integration service
Q.3) What is Pmcmd command?
A3) This command will be used when informatica is installed on unix
Q.4) What kind of problems you will get during production support?
-Expiration of password in databases
-Late feeds from upstream
-Getting incorrect source file
-Getting special characters and duplicate records in source file
-Environment issues like database is down
Q.5) What are the different scheduling tools?
A 5) Control-M, Autosys, IBM maestro
Q.6) Coding for un-committed look-up?
A 6) IIF (ISNULL(item_id), :lkp.mylookup(sku_numb)) ==> Part -1 is condition, part-2 is lookup. When condition is true, it calls look-up.
Q.7) Difference between connected look-up and un-connected look-up?
- Part of data mapping flow
- Returns multiple values
- Expected for every record passing
- More visible as lookup values are used
- Default values are used
- Separate from mapping data flow
- Returns only one value
- Only executed when look up function is called
- Less visible
- Default values are ignored
Q.8) Difference between Stop and Abort?
A 8) Stop – waits all running objects are completed
Abort- It stops in the middle
Q.9)Can we validate all mappings through query browser?
Q.10) What is infacmd command?
A 10) infacmd is a command-line program that allows you to administer domains, users, and services. Use infacmd to administer the following objects and services: Checkout here.