15 Mostly asked Informatica interview questions and answers
Top 15 Informatica interview questions and answers mostly asked in interviews in Accenture, Cognizant, Google etc.
| 1. How many ways you can update a relational source definition and what are they? Answer: Two ways : 1. Edit the definition 2. Reimport the definition |
| 2. While importing the relational source definition from the database, what is the metadata of the source you import? Answer: -Source name -Database location -Column names -Data types -Key constraints |
| 2. While importing the relational source definition from the database, what are the metadata of the source you import? Answer: -Source name -Database location -Column names -Data types -Key constraints |
| 4. Which transformation should you need while using the COBOL sources as source definitions? Answer: Normalizer transformation which is used to normalize the data, since COBOL sources consist of Denormalized data. |
| 5. To provide support for Mainframes source data, which files are used as a source definition? Answer: COBOL files |
| 6. How can you create or import flat file definitions into the warehouse designer? Answer: You can not create or import flat file definitions into the warehouse designer directly. Instead, U must analyze the file in the source analyzer, and then drag it into the warehouse designer. When you drag the flat file source definition into the warehouse designer workspace, the warehouse designer creates a relational target definition not a file definition. If you want to load to a file, configure the session to write to a flat file. When the Informatica server runs the session, it creates and loads the flat file. |
| 7. What is a transformation? Answer: It is a repository object that generates, modifies or passes data. |
| 8. What is a Mapplet? Answer: Mapplet is a set of transformations that you build in the Mapplet designer and U can use it in multiple mappings. |
| 9. What r the designer tools for creating transformations? Answer: -Mapping designer -Transformation developer -Mapplet designer |
| 10. What are the active and passive transformations? (In detailed difference) Answer: An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it. |
| 11. What are the connected or unconnected transformations? Answer: An unconnected transformation is not connected to other transformations in the mapping. Connected transformation is connected to other transformations in the mapping. |
| 12. What are the mapping parameters and mapping variables? Answer: The mapping parameter represents a constant value that U can define before running a session. A mapping parameter retains the same value throughout the entire session. When you use the mapping parameter, you declare and use the parameter in a mapping or maplet. Then define the value of the parameter in a parameter file for the session. Unlike a mapping parameter, a mapping variable represents a value that can change throughout the session. The Informatica server saves the value of the mapping variable to the repository at the end of the session run and uses that value the next time you run the session. |
| 13. How many ways do you create ports? Answer: Two ways 1. Drag the port from another transformation 2. Click the add button on the ports tab. |
| 14. What r the unsupported repository objects for a applet? Answer: -COBOL source definition -Joiner transformations -Normalizer transformations -Non-reusable sequence generator transformations. -Pre or post-session stored procedures -Target definitions -Power Mart 3.5 style Look Up functions -XML source definitions -IBM MQ source definitions |
| 15. What are the mapping parameters and mapping variables? The mapping parameter represents a constant value that U can define before running a session. A mapping parameter retains the same value throughout the entire session. When you use the mapping parameter, you declare and use the parameter in a mapping or maplet. Then define the value of the parameter in a parameter file for the session. Unlike a mapping parameter,a mapping variable represents a value that can change throughout the session. The Informatica server saves the value of the mapping variable to the repository at the end of the session run and uses that value the next time U run the session. |
Also Read :
1. What is the difference between Informatica PowerCenter and Informatica Cloud?
2.What is a Synchronization task in Informatica?
3.What is a Runtime environment in Informatica?
4.What is Check In Check Out in Informatica powercenter (Versioning)