Basics Of ETL And Informatica! Trivia Quiz

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 Thanu1234
T
Thanu1234
Community Contributor
Quizzes Created: 2 | Total Attempts: 2,229
| Attempts: 1,643
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/30 Questions

    Informatica is a reporting tool.

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


Are you familiar with the basics of ETL? The term stands for Extract, Transform, Load. One of the ETL features is that it provides a facility to specify many transformation rules with a GUI. It can generate programs to transform data. It handles multiple data sources. It supports data extraction, and it loads operations. You could learn more about the See morebasics of ETL, and you can challenge yourself with this quiz.

Basics Of ETL And Informatica! Trivia Quiz - Quiz

Quiz Preview

  • 2. 

    Power Center domain is the collection of?

    • Servers

    • Services

    • Repositories

    Correct Answer
    A. Servers
    Explanation
    Power Center domain is the collection of all the servers required to support Power Center functionality. services are done after the domain is configured. the domain contains repositories. the domain completely does not mean the collection of repositories since integration service is also can be done

    Rate this question:

  • 3. 

     The repository is nothing but

    • Collection of domain

    • Flat files

    • Xml

    • Relational database

    Correct Answer
    A. Relational database
    Explanation
    PowerCenter Repository: Repository is nothing but a relational database that stores all the metadata created in Power Center.

    Rate this question:

  • 4. 

    Which stores all the metadata created in Power Center?

    • Powercenter repository

    • Admin console

    • Integration service

    • Repository service

    Correct Answer
    A. Powercenter repository
    Explanation
    Whenever you develop mapping, session, workflow, execute them, or do anything meaningful (literally), entries are made in the Powercenter repository.

    Rate this question:

  • 5. 

    In the background, Informatica____  takes care of fetching data from source.

    • Workflow

    • Server

    • Designer

    • Session

    Correct Answer
    A. Server
    Explanation
    SERVER IS RESPONSIBLE, since when the server is established all the services are established.

    Rate this question:

  • 6. 

    Which of the following is true for the Informatica integration service? 

    • It is responsible to fetch the data from source and process it

    • It is responsible only to transform data

    Correct Answer
    A. It is responsible to fetch the data from source and process it
    Explanation
    integration service is responsible to fetch and process the data to target systems applying business logics

    Rate this question:

  • 7. 

    Which one of the following understands the contents of the repository?

    • Repository service

    • Integration service

    • Designer

    • Work flow manager

    Correct Answer
    A. Repository service
    Explanation
    •Repository Service: Repository Service is the one that understands content of the repository, fetches data from the repository and sends it back to the requesting components (mostly client tools and integration service

    Rate this question:

  • 8. 

    The PowerCenter Client connects to the __________ through the __________ to fetch data.

    • Repository,repository service

    • Repository service ,repository

    Correct Answer
    A. Repository,repository service
    Explanation
    The PowerCenter Client connects to the repository through the repository service to fetch data. The repository acts as a central storage location for metadata and other information related to the PowerCenter environment. The repository service manages the connections to the repository and provides access to the metadata stored in it. Therefore, the PowerCenter Client needs to connect to the repository through the repository service in order to fetch data.

    Rate this question:

  • 9. 

    PowerCenter Client Tools connects to the______________ to start _____________

    • Repositoryservice,workflows

    • Integrationservice ,workflows

    Correct Answer
    A. Integrationservice ,workflows
    Explanation
    •PowerCenter Client Tools: The PowerCenter Client consists of multiple tools. They are used to manage users, define sources and targets, build mappings and mapplets with the transformation logic, and create workflows to run the mapping logic. The PowerCenter Client connects to the repository through the Repository Service to fetch details. It connects to the Integration Service to start workflows. So essentially client tools are used to code and give instructions to PowerCenter servers.

    Rate this question:

  • 10. 

    What are the tools of power center clients?

    • Workflow manager

    • Designer

    • Workflow monitor

    • Repository monitor

    • Repository manager

    • Repository service

    • Repository service manager

    • Integration service

    Correct Answer(s)
    A. Workflow manager
    A. Designer
    A. Workflow monitor
    A. Repository manager
    Explanation
    option 1,2,3,5 are the tools of power center client

    Rate this question:

  • 11. 

    The components of the Informatica products are?

    • Informatica PowerCenter Client Tools

    • Informatica PowerCenter Repository

    • Informatica PowerCenter Server

    • Informatica Admin Console

    • Infromatica Metadata Model

    Correct Answer(s)
    A. Informatica PowerCenter Client Tools
    A. Informatica PowerCenter Repository
    A. Informatica PowerCenter Server
    Explanation
    1. Informatica PowerCenter Client Tools:
    These are the development tools installed at developer end
    2. Informatica PowerCenter Repository:
    Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica
    3. Informatica PowerCenter Server:
    Server is the place, where all the executions take place. Server makes physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.

    Rate this question:

  • 12. 

    Connected lookup caches all lookup columns while Unconnected lookup caches only the lookup output ports in the lookup conditions and the return port.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Connected lookup caches all lookup columns, which means it stores the values of all columns in the lookup table. This allows for faster retrieval of data during lookups as the cached values can be used instead of querying the database every time. On the other hand, unconnected lookup only caches the lookup output ports, which are the columns used in the lookup conditions and the return port. This means that only the necessary columns for the lookup operation are cached, resulting in more efficient memory usage. Therefore, the statement is true.

    Rate this question:

  • 13. 

    Which of the following are true for connected and unconnected lookups?

    • Connected Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)

    • Un connected Does not support user defined default values

    • Connected Does not support user defined default values

    • Un connected Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied

    Correct Answer(s)
    A. Connected Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)
    A. Un connected Does not support user defined default values
    Explanation
    Connected lookups support user-defined default values, which means that when the lookup conditions are not satisfied, a specific value can be returned. On the other hand, unconnected lookups do not support user-defined default values, meaning that when the lookup conditions are not met, no specific value can be returned. Therefore, the correct answer is that connected lookups support user-defined default values, while unconnected lookups do not.

    Rate this question:

  • 14. 

    Which of the following is true for router and filter?   Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C) Filter acts like WHERE condition is SQL.

    • Router and filter is true

    • Only router is true

    • Only filter is true

    • Either router and router is true

    Correct Answer
    A. Router and filter is true
    Explanation
    The statement that "Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C)" means that a router is used to direct network traffic based on specific conditions, similar to how a CASE statement in SQL or a switch().. case statement in C is used to direct program flow based on specific conditions.

    The statement that "Filter acts like WHERE condition in SQL" means that a filter is used to selectively allow or block network traffic based on specific criteria, similar to how a WHERE condition in SQL is used to selectively retrieve data from a database based on specific criteria.

    Rate this question:

  • 15. 

    What can we do to improve the performance of  Transformation in Informatica?

    • Aggregator

    • Lookup choose larger tables as master

    • Lookup choose smaller tables as master

    • Lookup choose any of the table as master

    Correct Answer(s)
    A. Aggregator
    A. Lookup choose smaller tables as master
    Explanation
    To improve the performance of Transformation in Informatica, we can use the aggregator transformation. Additionally, when using the lookup transformation, it is recommended to choose smaller tables as the master. This is because smaller tables have fewer records and can be processed faster, resulting in improved performance. Choosing larger tables as the master can slow down the lookup process due to the increased number of records to be processed. Therefore, selecting smaller tables as the master can enhance the overall performance of the transformation.

    Rate this question:

  • 16. 

    Under what condition selecting Sorted Input in aggregator may fail the session?

    • If the input data is not sorted correctly, the session will fail.

    • Also if the input data is properly sorted, the session may fail if the sort order by ports and the group by ports of the aggregator are not in the same order.

    • When mappping is valid

    • Session is not validated

    Correct Answer(s)
    A. If the input data is not sorted correctly, the session will fail.
    A. Also if the input data is properly sorted, the session may fail if the sort order by ports and the group by ports of the aggregator are not in the same order.
    Explanation
    If the input data is not sorted correctly or if the sort order by ports and the group by ports of the aggregator are not in the same order, selecting Sorted Input in aggregator may fail the session.

    Rate this question:

  • 17. 

    What are the types of groups are in router transformation?

    • Input grooup

    • Output group

    • User defined group

    • Default group

    • In out group

    Correct Answer(s)
    A. Input grooup
    A. Output group
    A. User defined group
    A. Default group
    Explanation
    The types of groups in the router transformation are input group, output group, user defined group, and default group. The input group represents the input ports of the router transformation, the output group represents the output ports, the user-defined group is created by the user to define specific conditions for routing data, and the default group is used when no other conditions match.

    Rate this question:

  • 18. 

    What are the output files are created when the Informatica session is running?

    • Server log

    • Session log

    • Session detail file

    • Performance detail file

    • Reject file

    • Control file

    • Indicator file

    • Output files

    • Cache files

    Correct Answer(s)
    A. Server log
    A. Session log
    A. Session detail file
    A. Performance detail file
    A. Reject file
    A. Control file
    A. Indicator file
    A. Output files
    A. Cache files
    Explanation
    When an Informatica session is running, several output files are created. The server log file contains information about the overall execution of the session. The session log file captures detailed information about the session's progress, including errors and warnings. The session detail file provides information about the target and source data. The performance detail file records performance-related statistics. The reject file contains data that failed to meet the session's transformation rules. The control file contains metadata information. The indicator file indicates the status of the session. Output files store the transformed data. Cache files are created to store temporary data during the session.

    Rate this question:

  • 19. 

    Is it possible to return two columns from an unconnected lookup?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    concatenate two columns how ever return port will be one

    Rate this question:

  • 20. 

    I have aggregator in my mapping and no group by the port on any column and I am passing 100 rows through aggregator .how many rows will I get as output?

    • First row

    • Hundread rows

    • Session fails

    • Last row

    Correct Answer
    A. Last row
    Explanation
    The question states that there is an aggregator in the mapping and no group by the port on any column. This means that the aggregator will treat all incoming rows as a single group and perform the aggregation operation on them. Since 100 rows are being passed through the aggregator, the output will be a single row containing the result of the aggregation. Therefore, the correct answer is "last row".

    Rate this question:

  • 21. 

    I have a mapping I have two heterogeneous sources where I don't have a common port can I use a join on it?

    • True

    • False

    Correct Answer
    A. False
    Explanation
    joiner is used in heterogenous sources where common port is mandatory where as union does not need any common port but it only unions on homogeneos sources.

    Rate this question:

  • 22. 

    Whenever you execute a particular workflow the output of the mapping (target table) is stored in

    • Designer

    • Integration service

    • Workflow

    • Repository server

    Correct Answer
    A. Repository server
    Explanation
    The output of the mapping (target table) is stored in the repository server whenever a particular workflow is executed. The repository server acts as a centralized storage location for all the metadata related to the informatica workflows, mappings, and other objects. It stores the output data in a structured manner, allowing easy access and retrieval of the results. This ensures that the output is securely stored and can be easily accessed by other processes or users as required.

    Rate this question:

  • 23. 

    Is it possible to create multiple instances of source or target?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    It is possible to create multiple instances of source or target. This means that you can have multiple sources or targets in a system, allowing for greater flexibility and scalability in data integration processes. Having multiple instances allows for parallel processing and can help improve overall system performance.

    Rate this question:

  • 24. 

    The debugger is monitored by using

    • Debug log

    • Target window

    • Navigation window

    • Mapping window

    • instance window

    Correct Answer(s)
    A. Debug log
    A. Target window
    A. Navigation window
    Explanation
    The debugger is monitored by using various tools and windows, including the debug log, target window, navigation window, mapping window, and instance window. The debug log provides a detailed record of the debugging process, allowing developers to track and analyze the execution of their code. The target window displays the current state of the program being debugged, allowing developers to inspect variables and control program flow. The navigation window helps developers navigate through the code and set breakpoints. The mapping window provides a visual representation of the program's structure, aiding in understanding and debugging. The instance window allows developers to inspect and manipulate objects during runtime.

    Rate this question:

  • 25. 

    Is it possible to modify the data and see the mappings and transformations, applets and targets when the data is moved through pipelines

    • If and only if the session fails

    • If and only if the integration service is failed

    • If the mapping is valid and the breakpoint is paused

    • If and only if the transformation is valid

    Correct Answer
    A. If the mapping is valid and the breakpoint is paused
  • 26. 

    Data recovery cannot be successful if

    • The mapping uses a Normalizer or Sequence Generator transformation

    • The data movement mode changes after the initial session failure

    • The source data is sorted

    • The transformation used in mapping must not be a mapplet

    • The number of instances in the mapping matches the recovery tables

    Correct Answer(s)
    A. The mapping uses a Normalizer or Sequence Generator transformation
    A. The data movement mode changes after the initial session failure
  • 27. 

    ___________ uses a hash function to group rows of data among partitions.

    • Repository service

    • Integration service

    • Workflow

    • Oracle/sap bui

    • Hub services

    Correct Answer
    A. Integration service
    Explanation
    The integration service uses a hash function to group rows of data among partitions. This means that the integration service will distribute the data evenly among the partitions based on the hash value generated by the hash function. This helps in achieving load balancing and efficient data processing across multiple nodes or servers.

    Rate this question:

  • 28. 

    I can make the deployment group as private by enabling the enable port in the repository?

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given statement is false. Enabling the port in the repository does not make the deployment group private. The deployment group's privacy settings are determined by the configuration and permissions set within the deployment group itself, not by enabling a port in the repository.

    Rate this question:

  • 29. 

    To tune performance Check which should I check

    • Collect Performance Data

    • Collect performance session

    Correct Answer
    A. Collect Performance Data
    Explanation
    To tune performance, it is important to collect performance data. This data provides valuable insights into the system's behavior and helps identify areas that need improvement. By collecting performance data, one can analyze various metrics such as CPU usage, memory utilization, disk I/O, and network traffic. This information enables the identification of bottlenecks or inefficiencies in the system, allowing for targeted optimizations. Therefore, collecting performance data is crucial in the process of tuning performance.

    Rate this question:

  • 30. 

    When you create a file source, target, or lookup definition, what are must define the properties of the file

    • File type

    • Null characters for fixed-width files

    • Delimiter types, quote character, and escape character for delimited files

    • Mapping root

    • Transformation path

    Correct Answer(s)
    A. File type
    A. Null characters for fixed-width files
    A. Delimiter types, quote character, and escape character for delimited files
    Explanation
    When creating a file source, target, or lookup definition, it is necessary to define the properties of the file. This includes specifying the file type, such as whether it is a fixed-width or delimited file. For fixed-width files, it is important to define the null characters. For delimited files, the delimiter types, quote character, and escape character must be defined. Additionally, the mapping root and transformation path need to be specified.

    Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

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

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 06, 2012
    Quiz Created by
    Thanu1234

Related Topics

Recent Quizzes

Wanna run Appium? Take this quiz first Wanna run Appium? Take this quiz first
Want to learn Appium? The foundational Appium Quiz Want to learn Appium? The foundational Appium Quiz
Every software developer should pass this test! Every software developer should pass this test!
Systems Integration Architecture Quiz! Systems Integration Architecture Quiz!
AWS-02 AWS-02
Ansys Structural Analysis Quiz Ansys Structural Analysis Quiz
Basics of Software Defined Radio Architectures and Building blocks of SDR waveform development for SDR Basics of Software Defined Radio Architectures and Building blocks of SDR waveform development for SDR
Python Pandas quiz questions with answers Python Pandas quiz questions with answers
Introduction to Power BI Introduction to Power BI

Featured Quizzes

Can You Guess These Asian's Nationality? Can You Guess These Asian's Nationality?
What Is My Ethnicity? Let's Take Ethnicity Quiz What Is My Ethnicity? Let's Take Ethnicity Quiz
Articles Quiz With Answers Articles Quiz With Answers
What Ethnicity Do I Look Like? What Ethnicity Do I Look Like?
Are You Ready For IQ Quiz: Test Your Intelligence Now Are You Ready For IQ Quiz: Test Your Intelligence Now
What Is My Talent? What Is My Talent?
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.