Informatica Certification Exams General Practice Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jeetu Dewda
Jeetu Dewda, Data Engineer
Jitendra, a proficient Data Engineer, excels in the world of data, using expertise to create, manage, and optimize data systems.
Quizzes Created: 1 | Total Attempts: 14,222
| Attempts: 14,255
SettingsSettings
Please wait...
  • 1/120 Questions

    Data Marts have specific business related purposes.

    • True
    • False
Please wait...
About This Quiz

This Informatica Certification Exams General Practice Test assesses knowledge in data warehousing and business intelligence. It covers key concepts such as organizational decision-making, data marts, operational data stores, and extraction processes.

Informatica Certification Exams General Practice Test - Quiz

Quiz Preview

  • 2. 

    How many ports are available in Expression Transformation

    • 3(input/output/variable)

    • 2

    • 1

    • 4

    • None

    Correct Answer
    A. 3(input/output/variable)
    Explanation
    Expression Transformation in Informatica PowerCenter is a transformation that allows users to perform transformations on data using expressions. It has three ports available - input, output, and variable ports. The input port is used to receive input data, the output port is used to send transformed data, and the variable port is used to store and manipulate variables within the transformation. Therefore, the correct answer is 3(input/output/variable).

    Rate this question:

  • 3. 

    How many internal tools available with Workflow manager to help you develop a workflow

    • 1

    • 3 (task developer, wf designer, worklet dsgn.)

    • 5

    • 7

    • 9

    Correct Answer
    A. 3 (task developer, wf designer, worklet dsgn.)
    Explanation
    Workflow Manager provides three internal tools to help you develop a workflow: task developer, workflow designer, and worklet designer. These tools assist in creating and managing tasks, designing workflows, and designing worklets respectively.

    Rate this question:

  • 4. 

    How many types of Workflow variables are available ?

    • 0

    • 1

    • 2 (pre-defined, user-defined)

    • 3

    • 4

    Correct Answer
    A. 2 (pre-defined, user-defined)
    Explanation
    There are two types of Workflow variables available: pre-defined and user-defined. Pre-defined variables are already defined in the system and can be used directly in the workflow. User-defined variables are created by the user and can be customized based on their specific needs.

    Rate this question:

  • 5. 

    The Repository Manager connects to the repository database through the Repository Server.

    • Depends upon the User

    • FALSE

    • TRUE

    • Only at some times

    • I don't know

    Correct Answer
    A. TRUE
    Explanation
    The statement is suggesting that the Repository Manager connects to the repository database through the Repository Server. This indicates that the Repository Manager relies on the Repository Server to establish a connection with the repository database. Therefore, the correct answer is TRUE.

    Rate this question:

  • 6. 

    Is it possible to run the workflow from particular task

    • Yes

    • No

    • Rarely

    • Sometimes

    • None

    Correct Answer
    A. Yes
    Explanation
    Yes, it is possible to run the workflow from a particular task. This means that instead of starting the workflow from the beginning, it can be initiated from a specific task within the workflow. This allows for more flexibility and control in the execution of the workflow, as it allows users to focus on specific tasks or sections of the workflow without having to go through the entire process.

    Rate this question:

  • 7. 

    Can the session be recovered?

    • Yes

    • No

    • Rarely

    • Sometimes

    • None

    Correct Answer
    A. Yes
    Explanation
    The answer "Yes" suggests that it is possible to recover the session.

    Rate this question:

  • 8. 

    In general, how many different types of log files are created by PowerCenter Server

    • 1

    • 2

    • 3 (session log,workflow log,reject log)

    • 4

    • I don't know

    Correct Answer
    A. 3 (session log,workflow log,reject log)
    Explanation
    PowerCenter Server creates three different types of log files: session log, workflow log, and reject log. These log files are used to track and monitor the execution of sessions, workflows, and to capture any rejected data during the ETL process.

    Rate this question:

  • 9. 

    Is it possible to generate a table in relational database using informatica

    • Yes

    • No

    • Sometimes

    • May be possible

    • None

    Correct Answer
    A. Yes
    Explanation
    It is possible to generate a table in a relational database using Informatica. Informatica is a data integration tool that allows users to extract, transform, and load data into a database. It provides features and functionalities to create and manage tables in a relational database. Therefore, using Informatica, users can generate tables in a relational database.

    Rate this question:

  • 10. 

    Is it possible to create  source and target definition manually

    • No

    • Yes

    • Sometimes

    • Rarely

    • None

    Correct Answer
    A. Yes
    Explanation
    Yes, it is possible to create source and target definitions manually. This means that users can manually define the structure and properties of the source and target data that will be used in a data integration or migration process. This allows for greater flexibility and customization in the data integration process.

    Rate this question:

  • 11. 

    How many modes are available for using pmcmd

    • 5

    • 4

    • 3

    • 2(interactive and commandline)

    • 0

    Correct Answer
    A. 2(interactive and commandline)
    Explanation
    The correct answer is 2(interactive and commandline). This means that there are two modes available for using pmcmd, which are interactive mode and commandline mode. Interactive mode allows users to enter commands and receive immediate feedback, while commandline mode allows users to run commands directly from the command line without any interaction.

    Rate this question:

  • 12. 

    Can we able to start and stop a workflow from workflow monitor

    • YES

    • NO

    • Depends on the privileges

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    The correct answer is YES because the workflow monitor allows users to start and stop workflows. This functionality is typically available to users with the necessary privileges to manage workflows.

    Rate this question:

  • 13. 

    When the Server runs in recovery mode, it continues to commit data from the point of the last successful commit

    • Only at some times

    • Depends upon the user

    • TRUE

    • FALSE

    • I don't know

    Correct Answer
    A. TRUE
    Explanation
    When the Server runs in recovery mode, it continues to commit data from the point of the last successful commit. This means that even if there was a failure or interruption during the server operation, the recovery mode ensures that the server picks up from where it left off and commits any pending data. Therefore, the statement "When the Server runs in recovery mode, it continues to commit data from the point of the last successful commit" is true.

    Rate this question:

  • 14. 

    Versioning is a concept where you can configure the repository to store multiple versions of objects

    • Only at some times

    • Depends upon the user

    • TRUE

    • FALSE

    • I don't know

    Correct Answer
    A. TRUE
    Explanation
    Versioning allows users to store multiple versions of objects in a repository. This means that whenever changes are made to an object, instead of overwriting the previous version, a new version is created and stored. This can be useful for tracking changes, reverting to previous versions, and collaborating with others on a project. Therefore, the statement "Versioning is a concept where you can configure the repository to store multiple versions of objects" is true.

    Rate this question:

  • 15. 

    When you connecting to the repository, you need to mention the

    • Your local machine's IP

    • Your Project Name

    • Host name and Port no

    • Your Mobile no

    • I don't know

    Correct Answer
    A. Host name and Port no
    Explanation
    When connecting to a repository, you need to mention the host name and port number. These details are necessary to establish a connection with the repository server and access the desired repository. The host name specifies the server where the repository is located, while the port number identifies the specific communication channel through which the connection is established. By providing the correct host name and port number, you can successfully connect to the repository and perform the desired actions.

    Rate this question:

  • 16. 

    If you want to use the same object in several projects, you need to put it in a shared folder

    • Depends upon the User

    • FALSE

    • TRUE

    • Only at some times

    • I don't know

    Correct Answer
    A. TRUE
    Explanation
    If a user wants to use the same object in several projects, they need to put it in a shared folder. This implies that the object cannot be stored in a project-specific folder but rather needs to be accessible from multiple projects. Therefore, the statement is true.

    Rate this question:

  • 17. 

    What is the return code for a successful pmcmd command execution

    • 1(not available--connection failed)

    • 0(successful)

    • 3(error)

    • 5(internal pmcmd error)

    • 7(invalid user)

    Correct Answer
    A. 0(successful)
    Explanation
    The return code for a successful pmcmd command execution is 0.

    Rate this question:

  • 18. 

    Can we have unlimited sessions in a workflow as we need

    • YES

    • NO

    • Depends on the privileges

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    Unlimited sessions in a workflow can be possible because there is no restriction on the number of sessions that can be created. This means that we can have as many sessions as we need to complete the workflow.

    Rate this question:

  • 19. 

    The Workflow Monitor displays workflows that have run

    • Never

    • Once

    • Twice

    • Thrice

    • I don't know

    Correct Answer
    A. Once
    Explanation
    The Workflow Monitor displays workflows that have run once.

    Rate this question:

  • 20. 

    When a mapplet is changed, all instances of the mapplet and all shortcuts to the mapplet

    • Will inherit the changes

    • Will start running

    • Will NOT inherit the changes

    • Will be closed

    • I don't know

    Correct Answer
    A. Will inherit the changes
    Explanation
    When a mapplet is changed, all instances of the mapplet and all shortcuts to the mapplet will inherit the changes. This means that any modifications made to the mapplet will be reflected in all the instances and shortcuts of the mapplet. The changes will be applied universally, ensuring consistency and accuracy across the board.

    Rate this question:

  • 21. 

    Like a reusable transformation, any change made to the mapplet is inherited by all instances of the mapplet.

    • NO

    • YES

    • Depends on the privileges

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    The given statement suggests that any change made to the mapplet is inherited by all instances of the mapplet. This means that if a change is made to the mapplet, it will automatically be applied to all instances where the mapplet is used. This indicates that the answer is "YES".

    Rate this question:

  • 22. 

    A block of memory for temporary storage of data likely to be used again is known as 

    • Session

    • Cache

    • Tables

    • Threads

    • I don't know

    Correct Answer
    A. Cache
    Explanation
    A block of memory for temporary storage of data likely to be used again is known as a cache. A cache is used to store frequently accessed data in order to improve the performance of a system. By keeping this data in a cache, the system can retrieve it quickly instead of having to access it from its original source, such as a database or a disk. Caching is commonly used in computer systems to optimize data access and reduce latency.

    Rate this question:

  • 23. 

    Which Component of informatica is used to see the performance of the workflow while running

    • Workflow Monitor

    • Mapping Designer

    • Workflow Manager

    • Repository Manager

    • Worklet Designer

    Correct Answer
    A. Workflow Monitor
    Explanation
    Workflow Monitor is the component of Informatica that is used to see the performance of the workflow while it is running. It provides real-time monitoring and tracking of workflows, sessions, and tasks. This allows users to view the status, progress, and statistics of the workflow, including details such as the number of rows read/written, transformation performance, and error messages. Workflow Monitor helps in troubleshooting and optimizing the performance of workflows by providing valuable insights into their execution.

    Rate this question:

  • 24. 

    What is the transformation used to convert the rows in to columns

    • Source Qualifier

    • Filter Transformation

    • Normalizer Transformation

    • Expression Transformation

    • Router Transformation

    Correct Answer
    A. Normalizer Transformation
    Explanation
    The Normalizer Transformation is used to convert rows into columns. It takes a single input row that contains multiple columns and converts it into multiple output rows, each containing a single column. This transformation is useful when dealing with denormalized data or when the target system requires data to be in a columnar format. It helps in restructuring the data and making it more organized for further processing.

    Rate this question:

  • 25. 

    When you create a workflow, the Workflow Designer creates which task by default

    • START

    • Command

    • Assignment

    • Email

    • Event

    Correct Answer
    A. START
    Explanation
    When you create a workflow, the Workflow Designer creates the "START" task by default. This is because the "START" task is the initial task that kicks off the workflow and defines the starting point for the workflow process. It acts as the entry point for the workflow and is responsible for triggering the subsequent tasks in the workflow sequence.

    Rate this question:

  • 26. 

    Last 3 performer in a department need to loaded in a target table. Which transformation can be used?

    • Aggregator Transformation

    • Expression transformation

    • Rank Transformation

    • Update Strategy

    • None

    Correct Answer
    A. Rank Transformation
    Explanation
    The Rank Transformation can be used to load the last 3 performers in a department into a target table. This transformation assigns a rank to each row based on a specified column, allowing us to filter and select only the rows with the desired rank. In this case, we would set the rank to be in ascending order based on the performers' performance, and then select the rows with ranks 1, 2, and 3 to load into the target table.

    Rate this question:

  • 27. 

    Is it possible to change  the sequence generator properties 

    • Yes

    • No

    • Rarely

    • Sometimes

    • None

    Correct Answer
    A. Yes
    Explanation
    Yes, it is possible to change the sequence generator properties. This means that the settings and characteristics of the sequence generator can be modified or adjusted according to specific requirements or preferences.

    Rate this question:

  • 28. 

    When the Informatica Server executes a worklet, it expands the worklet. 

    • YES

    • NO

    • Depends on the privileges

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    When the Informatica Server executes a worklet, it expands the worklet. This means that the worklet is expanded into its individual tasks and components, and each task is executed in the order specified in the worklet. This allows the Informatica Server to properly execute the worklet and perform the necessary transformations and data integration tasks. Therefore, the answer is YES.

    Rate this question:

  • 29. 

    In a short description, the data warehouse is a collection of data that is primarily used for

    • Organizational Decision Making

    • Transaction Processing

    • Temporary Data Storage

    • Query Optimization

    • Application Testing

    Correct Answer
    A. Organizational Decision Making
    Explanation
    A data warehouse is a collection of data that is specifically designed to support organizational decision making. It is a centralized repository that consolidates data from various sources and provides a platform for analyzing and reporting on the data. The purpose of a data warehouse is to provide decision-makers with easy access to accurate and consistent data, enabling them to make informed decisions and gain insights into the organization's performance and trends. Therefore, the correct answer is "Organizational Decision Making."

    Rate this question:

  • 30. 

    The Repository Server can manage a repository residing on a database on a different machine on the network

    • Depends upon the User

    • FALSE

    • TRUE

    • Only at some times

    • I don't know

    Correct Answer
    A. TRUE
    Explanation
    The Repository Server has the capability to manage a repository that is located on a different machine within the network. This means that the Repository Server can access and control the repository's data and resources, even if it is stored on a separate database on a different machine. Therefore, the statement is true.

    Rate this question:

  • 31. 

    If a task is invalid, the workflow becomes invalid

    • YES

    • NO

    • Depends on the privileges

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    If a task is invalid, it means that it cannot be completed or executed correctly. In a workflow, tasks are interconnected and dependent on each other. If one task is invalid, it can disrupt the flow and functionality of the entire workflow. Therefore, the statement "If a task is invalid, the workflow becomes invalid" is true.

    Rate this question:

  • 32. 

    What the option "Fail parent if this task fails' will do in session properties

    • Fails the parent if the current task fails

    • Fails current task when the parent fails

    • Fails the current and parent tasks

    • Fails only current task

    • None

    Correct Answer
    A. Fails the parent if the current task fails
    Explanation
    The option "Fail parent if this task fails" in session properties means that if the current task fails, it will also cause the parent task to fail. In other words, the failure of the current task will have a cascading effect and result in the failure of the parent task as well.

    Rate this question:

  • 33. 

    Is it possible to send an email after completion of a workflow in workflow manager

    • Decision

    • Yes

    • Event wait

    • Command

    • None

    Correct Answer
    A. Yes
    Explanation
    Yes, it is possible to send an email after the completion of a workflow in workflow manager. This can be achieved by configuring the workflow to include a step that sends an email notification once the workflow reaches its end state. The email can be sent to a specified recipient or a group of recipients, notifying them about the completion of the workflow and any relevant information or actions that need to be taken.

    Rate this question:

  • 34. 

    If the data doesn’t fit in the memory cache, the server stores the overflow values in

    • Variables

    • Parameters

    • Tables

    • Cache Files

    • I don't know

    Correct Answer
    A. Cache Files
    Explanation
    When the data doesn't fit in the memory cache, the server needs to store the overflow values somewhere. Cache files are used for this purpose. These files store the data that couldn't be stored in the memory cache, allowing the server to access it when needed. This helps optimize the performance of the server by efficiently managing the data storage and retrieval process.

    Rate this question:

  • 35. 

    Change data capture is a part of 

    • Incremental Extraction

    • Full Extraction

    • Online Extraction

    • Offline Extraction

    • None

    Correct Answer
    A. Incremental Extraction
    Explanation
    Change data capture is a method used to identify and track changes made to a database. It captures only the changes that have occurred since the last extraction, allowing for efficient and incremental updates to the data. Incremental extraction, as the correct answer, refers to the process of extracting only the changed data from a database using change data capture. This approach is commonly used in data integration and data warehousing scenarios to keep the target system up to date with the source system.

    Rate this question:

  • 36. 

    The latest informatica suite is compatible of

    • 8 Bit

    • 16 Bit

    • 32 Bit

    • 64 Bit

    • 128 Bit

    Correct Answer
    A. 64 Bit
    Explanation
    The latest Informatica suite is compatible with a 64-bit system. This means that it can run on computers or servers that have a 64-bit operating system installed. The 64-bit architecture allows for higher memory capacity and better performance compared to 32-bit systems. It also enables the software to handle larger datasets and perform complex calculations more efficiently.

    Rate this question:

  • 37. 

    Is it possible to use a transformation created in one mapping in any other mappings

    • Yes

    • No

    • Sometimes

    • Rarely

    • Frequently

    Correct Answer
    A. Yes
    Explanation
    It is possible to use a transformation created in one mapping in any other mappings. This is because transformations are reusable objects that can be used across multiple mappings. By using the same transformation in different mappings, we can save time and effort in development and maintenance. Additionally, it allows for consistency and standardization in data transformations across the organization.

    Rate this question:

  • 38. 

    Is it possible to create a worklet inside a worklet

    • Yes

    • No

    • Rarely

    • Sometimes

    • None

    Correct Answer
    A. Yes
    Explanation
    It is possible to create a worklet inside a worklet. This allows for nesting of worklets, where one worklet can be included within another worklet. This can be useful for organizing and structuring complex workflows or processes.

    Rate this question:

  • 39. 

    Using session properties, can we able to override parameters established in the mapping ?

    • Depends upon the User

    • NO

    • YES

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    Yes, using session properties, we can override parameters established in the mapping. Session properties provide a way to modify the behavior of a mapping at runtime. By changing the values of session properties, we can override the default values set in the mapping. This allows for greater flexibility and customization in the execution of the mapping.

    Rate this question:

  • 40. 

    Can a command task can be re-used

    • Depends on the privileges

    • NO

    • YES

    • Only at some times

    • I don't know

    Correct Answer
    A. YES
    Explanation
    A command task can be re-used if the user has the necessary privileges to do so. This means that if the user has the authority and permissions to reuse a command task, then they can do it. However, if the user does not have the required privileges, they will not be able to reuse the command task. Therefore, whether a command task can be re-used or not depends on the privileges of the user.

    Rate this question:

  • 41. 

    Which  informatica client tool is used to know the run time  and status of a workflow

    • Repository Manager

    • Designer

    • Workflow Manager

    • Workflow Monitor

    • None

    Correct Answer
    A. Workflow Monitor
    Explanation
    Workflow Monitor is the correct answer because it is the Informatica client tool that is used to track the runtime and status of a workflow. It provides real-time information about the execution of workflows, including details such as start time, end time, error messages, and the overall status of the workflow. This tool is essential for monitoring and troubleshooting workflows during their execution. Repository Manager, Designer, and Workflow Manager are other Informatica client tools, but they do not specifically provide information about the runtime and status of workflows.

    Rate this question:

  • 42. 

    The process of pulling data from various hetrogeneous source systems is known as

    • Loading

    • Transforming

    • Cleansing

    • Refreshing

    • Extraction

    Correct Answer
    A. Extraction
    Explanation
    The process of pulling data from various heterogeneous source systems is known as extraction. This involves extracting data from different sources and bringing it together into a central location for further processing and analysis. Extraction is the first step in the ETL (Extract, Transform, Load) process, where data is extracted from multiple sources, transformed into a consistent format, and then loaded into a data warehouse or another destination system.

    Rate this question:

  • 43. 

    How the repository server communicates with the repository database

    • Through native drivers

    • Third party softwares

    • LAN Drivers

    • Logical Paths

    • I don't know

    Correct Answer
    A. Through native drivers
    Explanation
    The repository server communicates with the repository database through native drivers. Native drivers are software components that allow the server to interact directly with the database using the database's native communication protocol. This ensures efficient and secure communication between the server and the database, without the need for any third-party software or additional drivers.

    Rate this question:

  • 44. 

    What is the pmcmd command for instructing the server to execute the subsequent commands in the wait mode.

    • Setfolder

    • Usefolder

    • Setnowait

    • Setwait

    • Showsettings

    Correct Answer
    A. Setwait
    Explanation
    The correct answer is "setwait." This command is used to instruct the server to execute subsequent commands in the wait mode. This means that the server will wait for each command to complete before moving on to the next one.

    Rate this question:

  • 45. 

    The center of Star schema consists of one or more 

    • Fact tables

    • Dimension tables

    • Indexes

    • Views

    • Synonyms

    Correct Answer
    A. Fact tables
    Explanation
    The center of a Star schema consists of one or more Fact tables. Fact tables are the central tables in a Star schema that store the quantitative and numerical data. They contain the measurements or metrics of a business process or event. Dimension tables, on the other hand, are connected to the Fact tables and provide descriptive attributes or context for analyzing the data in the Fact tables. Indexes, views, and synonyms are not specific to the center of a Star schema and are not directly related to the organization of the schema.

    Rate this question:

  • 46. 

    You can create and maintain folders in the

    • Repository Manager

    • Designer

    • Workflow Manager

    • Workflow Monitor

    • Repository Server

    Correct Answer
    A. Repository Manager
    Explanation
    The correct answer is Repository Manager because it is the tool used to create and maintain folders in the repository. This tool allows users to organize and manage their files and resources within the repository, making it easier to navigate and locate specific items. The other options listed are not specifically designed for creating and maintaining folders in the repository.

    Rate this question:

  • 47. 

    The place where debugger pauses and allows you to view and edit transformation output data is known as 

    • Break Views

    • Break Points

    • Break Windows

    • Break Sessions

    • I don't know

    Correct Answer
    A. Break Points
    Explanation
    A debugger allows you to pause the execution of a program at specific points in order to view and edit the data. These points are called "break points". At a break point, you can analyze the current state of the program and make necessary changes to the transformation output data.

    Rate this question:

  • 48. 

    Flat file lookup is one newly added feature in Informatica PowerCenter 7.1version

    • Depends upon the User

    • NO

    • I don't know

    • Only at some times

    • YES

    Correct Answer
    A. YES
    Explanation
    The given statement suggests that the feature of flat file lookup was newly added in Informatica PowerCenter 7.1 version. The answer "YES" indicates that the statement is correct and the feature was indeed added in that version.

    Rate this question:

  • 49. 

    If a sorter transformation is used before Aggregator transformation.Will the performance degrades.

    • No

    • Yes

    • Sometimes

    • None

    • Rarely

    Correct Answer
    A. No
    Explanation
    The performance will not degrade if a sorter transformation is used before an Aggregator transformation. The sorter transformation sorts the data based on specified criteria before passing it to the Aggregator transformation. This sorting can actually improve the performance of the Aggregator transformation as it reduces the amount of data that needs to be processed.

    Rate this question:

Quiz Review Timeline (Updated): Nov 10, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Nov 10, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 06, 2016
    Quiz Created by
    Jeetu Dewda
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.