10 Informatica ETL Questions asked at CGI

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?

A 7)

Connected lookup:

  • Part of data mapping flow
  • Returns multiple values
  • Expected for every record passing
  • More visible as lookup values are used
  • Default values are used

Un-connected lookup

  • 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?

A9) Yes.

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.

Keep Reading

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.