Basics Of ETL And Informatica! Trivia Quiz
(178).jpg "Basics Of ETL And Informatica! Trivia Quiz - 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 basics of ETL, and you can challenge yourself with this quiz.
- 1.
Informatica is a reporting tool.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Informatica is an ETL TOOL.Rate this question:
-
- 2.
Power Center domain is the collection of?
- A.
Servers
- B.
Services
- C.
Repositories
Correct Answer
A. ServersExplanation
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 doneRate this question:
-
- 3.
The repository is nothing but
- A.
Collection of domain
- B.
Flat files
- C.
Xml
- D.
Relational database
Correct Answer
D. Relational databaseExplanation
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?
- A.
Powercenter repository
- B.
Admin console
- C.
Integration service
- D.
Repository service
Correct Answer
A. Powercenter repositoryExplanation
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.
- A.
Workflow
- B.
Server
- C.
Designer
- D.
Session
Correct Answer
B. ServerExplanation
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?
- A.
It is responsible to fetch the data from source and process it
- B.
It is responsible only to transform data
Correct Answer
A. It is responsible to fetch the data from source and process itExplanation
integration service is responsible to fetch and process the data to target systems applying business logicsRate this question:
-
- 7.
Which one of the following understands the contents of the repository?
- A.
Repository service
- B.
Integration service
- C.
Designer
- D.
Work flow manager
Correct Answer
A. Repository serviceExplanation
•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 serviceRate this question:
-
- 8.
The PowerCenter Client connects to the __________ through the __________ to fetch data.
- A.
Repository,repository service
- B.
Repository service ,repository
Correct Answer
A. Repository,repository serviceExplanation
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 _____________
- A.
Repositoryservice,workflows
- B.
Integrationservice ,workflows
Correct Answer
B. Integrationservice ,workflowsExplanation
•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?
- A.
Workflow manager
- B.
Designer
- C.
Workflow monitor
- D.
Repository monitor
- E.
Repository manager
- F.
Repository service
- G.
Repository service manager
- H.
Integration service
Correct Answer(s)
A. Workflow manager
B. Designer
C. Workflow monitor
E. Repository managerExplanation
option 1,2,3,5 are the tools of power center clientRate this question:
-
- 11.
The components of the Informatica products are?
- A.
Informatica PowerCenter Client Tools
- B.
Informatica PowerCenter Repository
- C.
Informatica PowerCenter Server
- D.
Informatica Admin Console
- E.
Infromatica Metadata Model
Correct Answer(s)
A. Informatica PowerCenter Client Tools
B. Informatica PowerCenter Repository
C. Informatica PowerCenter ServerExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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?
- A.
Connected Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)
- B.
Un connected Does not support user defined default values
- C.
Connected Does not support user defined default values
- D.
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)
B. Un connected Does not support user defined default valuesExplanation
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.
- A.
Router and filter is true
- B.
Only router is true
- C.
Only filter is true
- D.
Either router and router is true
Correct Answer
A. Router and filter is trueExplanation
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?
- A.
Aggregator
- B.
Lookup choose larger tables as master
- C.
Lookup choose smaller tables as master
- D.
Lookup choose any of the table as master
Correct Answer(s)
A. Aggregator
C. Lookup choose smaller tables as masterExplanation
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?
- A.
If the input data is not sorted correctly, the session will fail.
- B.
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.
- C.
When mappping is valid
- D.
Session is not validated
Correct Answer(s)
A. If the input data is not sorted correctly, the session will fail.
B. 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?
- A.
Input grooup
- B.
Output group
- C.
User defined group
- D.
Default group
- E.
In out group
Correct Answer(s)
A. Input grooup
B. Output group
C. User defined group
D. Default groupExplanation
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?
- A.
Server log
- B.
Session log
- C.
Session detail file
- D.
Performance detail file
- E.
Reject file
- F.
Control file
- G.
Indicator file
- H.
Output files
- I.
Cache files
Correct Answer(s)
A. Server log
B. Session log
C. Session detail file
D. Performance detail file
E. Reject file
F. Control file
G. Indicator file
H. Output files
I. Cache filesExplanation
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?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
concatenate two columns how ever return port will be oneRate 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?
- A.
First row
- B.
Hundread rows
- C.
Session fails
- D.
Last row
Correct Answer
D. Last rowExplanation
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?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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
- A.
Designer
- B.
Integration service
- C.
Workflow
- D.
Repository server
Correct Answer
D. Repository serverExplanation
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?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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
- A.
Debug log
- B.
Target window
- C.
Navigation window
- D.
Mapping window
- E.
instance window
Correct Answer(s)
A. Debug log
B. Target window
C. Navigation windowExplanation
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
- A.
If and only if the session fails
- B.
If and only if the integration service is failed
- C.
If the mapping is valid and the breakpoint is paused
- D.
If and only if the transformation is valid
Correct Answer
C. If the mapping is valid and the breakpoint is paused -
- 26.
Data recovery cannot be successful if
- A.
The mapping uses a Normalizer or Sequence Generator transformation
- B.
The data movement mode changes after the initial session failure
- C.
The source data is sorted
- D.
The transformation used in mapping must not be a mapplet
- E.
The number of instances in the mapping matches the recovery tables
Correct Answer(s)
A. The mapping uses a Normalizer or Sequence Generator transformation
B. The data movement mode changes after the initial session failure -
- 27.
___________ uses a hash function to group rows of data among partitions.
- A.
Repository service
- B.
Integration service
- C.
Workflow
- D.
Oracle/sap bui
- E.
Hub services
Correct Answer
B. Integration serviceExplanation
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?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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
- A.
Collect Performance Data
- B.
Collect performance session
Correct Answer
A. Collect Performance DataExplanation
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
- A.
File type
- B.
Null characters for fixed-width files
- C.
Delimiter types, quote character, and escape character for delimited files
- D.
Mapping root
- E.
Transformation path
Correct Answer(s)
A. File type
B. Null characters for fixed-width files
C. Delimiter types, quote character, and escape character for delimited filesExplanation
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 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 06, 2012Quiz Created by
Thanu1234