---
title: "10 Informatica ETL Questions asked at CGI"
description: "10 best selected interview questions asked at CGI."
url: https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/
date: 2016-02-17
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2016/02/pexels-photo-1172542.jpeg?fit=1880%2C1253&ssl=1
categories: ["ETL", "Informatica"]
tags: ["ETL testing interview questions"]
type: post
lang: en
---

# 10 Informatica ETL Questions asked at CGI

Here are the ETL [Informatica interview questions](https://srinimf.com/2017/04/19/informatica-interview-questions-part-2-of-2/) asked in CGI.

Related[IBM InfoSphere DataStage](https://srinimf.com/2015/04/05/ibm-infosphere-datastage/)

## 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?**

A4)

```
-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.](https://docs.informatica.com/data-integration/powercenter/10-4-1/command-reference/using-infacmd/using-infacmd-overview.html)

Keep Reading

- [Frequently asked Informatica Interview Questions](https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/)DateAugust 24, 2015
- [Informatica – Mapping Optimization](https://srinimf.com/2013/12/18/informatica-mapping-optimization/)DateDecember 18, 2013
- [3 Top Informatica Books to Read Right now](https://srinimf.com/2016/11/24/my-3-best-informatica-books-for-an-awesome-reference/)DateNovember 24, 2016

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2016%2F02%2F17%2F10-informatica-etl-questions-aksed-at-cgi%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2016%2F02%2Fpexels-photo-1172542.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=10%20Informatica%20ETL%20Questions%20asked%20at%20CGI)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%2010%20Informatica%20ETL%20Questions%20asked%20at%20CGI&body=https%3A%2F%2Fsrinimf.com%2F2016%2F02%2F17%2F10-informatica-etl-questions-aksed-at-cgi%2F&share=email)
-

### Like this:

Like Loading…