--- title: "Frequently asked Informatica Interview Questions" description: "The Informatica general interview questions asked in many interviews. These really good questions are highly suitable for production supports ETL developers working on Informatica tool." url: https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/ date: 2015-08-24 modified: 2026-10-10 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/08/pexels-photo-5461553.jpeg?fit=1880%2C1255&ssl=1 categories: ["Informatica"] tags: ["Informatica Careers", "Informatica Interview questions"] type: post lang: en --- # Frequently asked Informatica Interview Questions The following are the interview [questions asked at](https://srinimf.com/2016/02/17/10-informatica-etl-questions-aksed-at-cgi/) CGI for Informatica developers. [You can read Informatica’s complete list of interview questions and answers here](http://amzn.to/2pf4BDy). **1. What type of testing will do in the project?** Unit testing, System testing, Integration testing **2. How many ways we can do performance tuning in Informatica?** Optimize the target. Enables the Integration Service to write to the targets efficiently. - Optimize the source. Enables the Integration Service to read source data efficiently. - Optimize the mapping. Enables the Integration Service to transform and move data efficiently. - Optimize the transformation. Enables the Integration Service to process transformations in a mapping efficiently. - Optimize the session. Enables the Integration Service to run the session more quickly. - Optimize the grid deployments. Enables the Integration Service to run on a grid with optimal performance. - Optimize the PowerCenter components. Enables the Integration Service and Repository Service to function optimally. - Optimize the system. Enables PowerCenter service processes to run more quickly **3. What is pmcmd command?** pmcmd- is built-in command line program. There are 4 built-in command-line program utilities: – infacmd – infasetup – pmcmd – pmrep Scheduling the work flow pmcmd scheduleworkflow -service Informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name. You can not specify scheduling options here. Start workflow pmcmd startworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name Start workflow from a task pmcmd startask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name -startfrom task-name -Stops specified task instance pmcmd stoptask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name -Aborting workflow and task pmcmd abortworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name pmcmd aborttask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name **4. What are the different problems you will face in production support?** Expiration of passwords in databases Late feeds from up-stream, Getting incorrect source fields, Getting special characters and duplicate values, Environment issues like databases are down, and the repository is down, Spaces on the server, etc., **5. What are the different Scheduler tools used in Data warehousing?** Control-M, Autosys, IBM Maestro **6. What is push-down optimization in Informatica?** Push down optimization option, improves performance by enabling processes to be pushed down to the relational databases, maximizing flexibility, minimizing data movement, and providing optimal performance to both data-intensive and process-intensive transformations. **7. How source analyzer connected to the Repository?** Source analyzer==> Repo server ==> TCP/IP ==>Repo agent==> Repository **8. Differences between connected look-up and un-connected look-up?** Connected Lookup-Part of mapping data flow, Returns multiple values, Executed for every record passing through the transformation, More visible as lookup values are used, Default values are used Un-connected look-up-Separate from mapping data flow Returns only one value Only executed when lookup function is called Less visible Default values are ignored. Recent posts - [![How to Find Databricks Job Status, Owner, and Active Runs Fast](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/10/pexels-photo-30972899.jpeg?resize=867%2C1300&ssl=1)](https://srinimf.com/2026/10/17/databricks-find-job-status/) ## [How to Find Databricks Job Status, Owner, and Active Runs Fast](https://srinimf.com/2026/10/17/databricks-find-job-status/) Need to audit Databricks workflows? Step-by-step guide to tracking job creators, service principal run identities, and current execution status in Databricks. - [![30 SQL Practice Queries with Solutions — Run Them Live](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/10/pexels-photo-5530473.jpeg?resize=867%2C1300&ssl=1)](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) ## [30 SQL Practice Queries with Solutions — Run Them Live](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) Practice 30 SQL queries with solutions, from SELECT and JOINs to subqueries and window functions. Run SQL queries live in an interactive SQL Playground. - [![Supercharge Your Database Skills: Try Our New Interactive SQL Plugin!](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/09/pexels-photo-1181469.jpeg?resize=1880%2C1255&ssl=1)](https://srinimf.com/2026/09/30/supercharge-your-database-skills-try-our-new-interactive-sql-plugin/) ## [Supercharge Your Database Skills: Try Our New Interactive SQL Plugin!](https://srinimf.com/2026/09/30/supercharge-your-database-skills-try-our-new-interactive-sql-plugin/) Struggling with database queries? Explore our new interactive SQL plugin to write, test, and master SQL directly in your browser. Try the live demo now! ### 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%2F2015%2F08%2F24%2Finformatica-interview-questions-part-1-of-2%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F08%2Fpexels-photo-5461553.jpeg%3Ffit%3D1200%252C801%26ssl%3D1&description=Frequently%20asked%20Informatica%20Interview%20Questions) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/08/24/informatica-interview-questions-part-1-of-2/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Frequently%20asked%20Informatica%20Interview%20Questions&body=https%3A%2F%2Fsrinimf.com%2F2015%2F08%2F24%2Finformatica-interview-questions-part-1-of-2%2F&share=email) - ### Like this: Like Loading…