10 Informatica ETL Questions asked at CGI

Q.1) What kind of testing you people will do?

A) Unit testing, System testing, and Integration testing

Q.2) What is Push down performance in informatica?

A) It pushes activities of source on the target database, instead of integration service

Q.3) What is Pmcmd command?

A) This command will be used when informatica is installed on unix

Q.5) What kind of problems you will get during production support?

A) -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.6) What are the different scheduling tools?

A) Control-M, Autosys, IBM maestro

Q.7)  Coding for un-committed look-up?

A) 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.8) Difference between connected look-up and un-connected look-up?

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.9) Difference between Stop and Abort?

A) Stop – waits all running objects are completed

Abort- It stops in the middle

Q.10)Can we validate all mappings through query browser?

A) Yes.