🧪 Informatica IPaaS MCQ Quiz Hub

1. Which one is not correct about filter transformation?
Passes multiple conditions
Can't passes multiple conditions
Act like 'Case' in pl/sql
Act as a 'where' condition

2. Reusable component in Informatica are:
Session
Workflow
Mapplet
Mapping

3. OLAP stands for______
On-Line Access Processing
On-Line Analysis Processing
On-Line Analytical Processing
On-Line Application processing

4. Two types of Repositories in Informatica are:
Local Repositories
Global Repositories
National Repositories
Both A & B

5. What ETL Stands for_____
Extract, Transform, Load
Extreme, Transform, Load
Enable, Transactions, Load
None of the above

6. Which of the following is not an ETL tool?
Datastage
Informatica
Visual studio
DT/studio.

7. A partition executes in a________.
single reader, or writer thread
multiple reader, transformation, or writer thread
single reader, transformation, or writer thread
single reader, multiple transformation, or multiple writer thread

8. What are the services & components of the Informatica ETL tool?
Informatica Designer
Workflow Monitor
Repository Manager
All of the above

9. Integration service is the ___ for the Informatica.
executing engine
ETL Tool
SOA
None of the above

10. Which of the following server governs the implementation of various processes among the factors of server’s database repository.
Temp server
Repository server
Domain server
Powerhouse server

11. Which of the following transformation is used to combine data from different sources?
Lookup transformation
Joiner transformation
Union Transformation
Expression transformation

12. What is the full form of OLAP?
On-Line Analytical Processing
On-Line Analysis Processing
On-Line Access Processing
On-Line Application processing

13. Which of the following transformation is used to handle cobol sources?
Filter Transformation
Source Qualifier
Normalizer Transformation
Expression Transformation

14. Which of the following option is need to be checked for creating shortcuts for folders?
Shortcuts
Create Shortcuts
Allow shortcut
None of the above

15. ___ are objects which can be referenced throughout the mapping run (to access their values) and their values can be reassigned.
Mapping variables
Mapping Parameters
Mapping designer
All of the above

16. if you have a session named 's_m_employee_detail' then workflow for the same can be named as '___'.
wkf_s_m_employee_detail
s_m_employee_detail_wkf_
s_m_employee_detail.wkf_
All of the above

17. Parameters are created in which tool?
Designer
Workflow monitor
Repository manager
Admin console

18. Which of the following cashes used in informatica?
Static
Dynamic
dynamic,static
Dynamic,Static,persistent

19. Which schema is a good alternative to the star schema.
Star schema.
Fact constellation.
Snowflake schema.
Star-snowflake schema.

20. Type of relationship in star schema is______
one-to-one.
one-to-many.
many-to-one.
many-to-many.

21. Flatfile cannot be used for
Aggregator
Source
Lookup
Target

22. Which of the following transformation is used to combine data from different sources?
Union Transformation
Joiner transformation
Joiner transformation
Expression transformation

23. Which of the following transformation is used to handle cobol sources?
Source Qualifier
Normalizer Transformation
Filter Transformation
Expression Transformation

24. Different Components of PowerCenter?
Repository Service
PowerCenter Clients
PowerCenter Service
All of the above

25. Which one is reusable component in Informatica?
Mapping
Mapplet
Session
Workflow

26. Which of the following session property enabled when update strategy is used in a mapping?
DD_UPDATE
DD_INSERT
Data Driven
DD_REJECT

27. Which task is used anywhere in the workflow to run the shell commands?
Session Task
email Task
Command Task
Standalone Command Task

28. Which process is used for online analytical processing?
Data
Database
Data mart
Data warehouse

29. Which of the following transformation is not using to connect more than one table?
joiner
source qualifier
lookup
sorter

30. Which Component gets metadata from Repository?
Informatica Server
Informatica Designer
Informatica Workflow Designer
Informatica Repository service

31. Which one is not an active transformation?
Store Procedure
Sequence generator
SQL
Normalizer

32. Informatica is a software development company founded in ...............
1990
1991
1992
1993

33. Which of the following Function(s) cannot be used in Expression Widget?
AVG
TRIM
LTRIM
RTRIM

34. ............... test is used in an online transactional processing environment.
ACID
MEGA
MICRO
MACRO

35. Which of the following client component can be used for creating Repository?
Designer
Workflow Manager
Repository Manager
Repository Server Administration Console

36. What does an informatica variable contains?
startvalue/end value
start value/current value
start value/dynamic value
start value/persistent value

37. What is the purpose of SQL override?
It is used to write user defined SQL statements in source qualifier and look up transformations.
Write to cache files
Performance tuning
None of the above

38. The repository server create and update the repository tables through
Native drivers
LAN Drivers
PSTN Lines
Repository agent process

39. Which of the following transformation is used to convert the rows in to columns?
Filter Transformation
Source Qualifier
Normalizer Transformation
Router Transformation

40. Which of the following Transformation is used to load the rejected records?
Source Qualifier
Router Transformation
Filter Transformation
None of the above

41. What is the function of SCD (Slowly Changing Dimension)?
manage data
manage workflow
manage session
None of the above

42. Which of the following types of sources are available in informatica?
Flatfiles
Cobol and XML sources
Homogeneous & Heterogeneous
All of the above

43. Which of the following component of informatica is used to see the performance of the workflow while running?
Mapping Designer
Workflow Monitor
Worklet Designer
Workflow Manager

44. What are the two types of Repositories in INFORMATICA?
Global Repositories
Local Repositories
National Repositories
Both A & B