1. Which command is used to load data into PowerCenter from a relational database?
Session
Workflow
Mapping
Reader
Show Answer
✅ Correct Answer: Session
2. Which component of Informatica PowerCenter is used to transform the data?
Transformation
Source
Target
Session
Show Answer
✅ Correct Answer: Transformation
3. What is the main purpose of the Lookup Transformation in PowerCenter?
Join data from two sources
Sort data
Aggregate data
Filter data
Show Answer
✅ Correct Answer: Join data from two sources
4. Which transformation is used for performing calculations on groups of data?
Aggregator
Expression
Filter
Router
Show Answer
✅ Correct Answer: Aggregator
5. Which repository service provides metadata storage for all PowerCenter objects?
Repository Service
Integration Service
Session Service
PowerCenter Service
Show Answer
✅ Correct Answer: Repository Service
6. Which transformation is used to remove duplicate records in a dataset?
Sorter
Filter
Router
Joiner
Show Answer
✅ Correct Answer: Sorter
7. Which transformation can be used to perform complex data manipulation in PowerCenter?
Expression
Aggregator
Rank
Joiner
Show Answer
✅ Correct Answer: Expression
8. What is the main role of the Integration Service in Informatica PowerCenter?
Execute mappings and workflows
Store metadata
Generate error logs
Define transformation logic
Show Answer
✅ Correct Answer: Execute mappings and workflows
9. Which transformation is used for splitting a dataset based on defined conditions?
Router
Aggregator
Joiner
Expression
Show Answer
✅ Correct Answer: Router
10. Which component is responsible for managing user security and access in Informatica PowerCenter?
Administrator
Repository Service
Integration Service
PowerCenter Service
Show Answer
✅ Correct Answer: Administrator
11. Which transformation is used to rank rows based on a specific condition?
Rank
Expression
Aggregator
Joiner
Show Answer
✅ Correct Answer: Rank
12. What is the purpose of the Source Qualifier Transformation in PowerCenter?
Read data from a source
Filter data
Sort data
Aggregate data
Show Answer
✅ Correct Answer: Read data from a source
13. Which transformation is used to combine data from multiple sources?
Joiner
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Joiner
14. What is the purpose of the Workflow Manager in PowerCenter?
Schedule and execute workflows
Design mappings
Store metadata
Define transformations
Show Answer
✅ Correct Answer: Schedule and execute workflows
15. Which transformation is used to filter rows based on a condition?
Filter
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Filter
16. What is the purpose of the Target Load Order in PowerCenter?
Control the order in which data is loaded into targets
Sort source data
Filter source data
Aggregate source data
Show Answer
✅ Correct Answer: Control the order in which data is loaded into targets
17. Which transformation is used to generate sequence numbers for rows?
Sequence Generator
Expression
Aggregator
Joiner
Show Answer
✅ Correct Answer: Sequence Generator
18. What is the purpose of the Update Strategy Transformation in PowerCenter?
Define how to update or insert records in a target
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Define how to update or insert records in a target
19. Which transformation is used to normalize data in PowerCenter?
Normalizer
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Normalizer
20. What is the purpose of the Stored Procedure Transformation in PowerCenter?
Execute database stored procedures
Filter data
Sort data
Aggregate data
Show Answer
✅ Correct Answer: Execute database stored procedures
21. Which transformation is used to pivot rows into columns?
Pivot
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Pivot
22. What is the purpose of the Transaction Control Transformation in PowerCenter?
Commit or rollback transactions
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Commit or rollback transactions
23. Which transformation is used to unpivot columns into rows?
Unpivot
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Unpivot
24. What is the purpose of the XML Parser Transformation in PowerCenter?
Parse XML data
Filter XML data
Sort XML data
Aggregate XML data
Show Answer
✅ Correct Answer: Parse XML data
25. Which transformation is used to merge data from multiple pipelines?
Union
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Union
26. What is the purpose of the Debugger in PowerCenter?
Test and debug mappings
Schedule workflows
Store metadata
Define transformations
Show Answer
✅ Correct Answer: Test and debug mappings
27. Which transformation is used to handle NULL values in PowerCenter?
Expression
Router
Aggregator
Joiner
Show Answer
✅ Correct Answer: Expression
28. What is the purpose of the Reusable Transformation in PowerCenter?
Reuse transformation logic across mappings
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Reuse transformation logic across mappings
29. Which transformation is used to perform conditional splits in PowerCenter?
Router
Expression
Aggregator
Joiner
Show Answer
✅ Correct Answer: Router
30. What is the purpose of the Mapping Parameter in PowerCenter?
Pass values to mappings at runtime
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Pass values to mappings at runtime
31. Which transformation is used to perform row-level calculations in PowerCenter?
Expression
Router
Aggregator
Joiner
Show Answer
✅ Correct Answer: Expression
32. What is the purpose of the Mapping Variable in PowerCenter?
Store values that can change during a session
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Store values that can change during a session
33. Which transformation is used to perform data validation in PowerCenter?
Expression
Router
Aggregator
Joiner
Show Answer
✅ Correct Answer: Expression
34. What is the purpose of the Worklet in PowerCenter?
Group reusable tasks in workflows
Filter rows
Sort rows
Aggregate rows
Show Answer
✅ Correct Answer: Group reusable tasks in workflows
35. Which transformation is used to perform data masking in PowerCenter?
Data Masking
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Data Masking
36. What is the purpose of the Task Developer in PowerCenter?
Create tasks for workflows
Design mappings
Store metadata
Define transformations
Show Answer
✅ Correct Answer: Create tasks for workflows
37. Which transformation is used to perform data encryption in PowerCenter?
Data Encryption
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Data Encryption
38. What is the purpose of the Repository Manager in PowerCenter?
Manage repository objects
Schedule workflows
Store metadata
Define transformations
Show Answer
✅ Correct Answer: Manage repository objects
39. Which transformation is used to perform data decryption in PowerCenter?
Data Decryption
Router
Expression
Aggregator
Show Answer
✅ Correct Answer: Data Decryption
40. What is the purpose of the PowerCenter Designer?
Design mappings and transformations
Schedule workflows
Store metadata
Execute workflows
Show Answer
✅ Correct Answer: Design mappings and transformations
41. Which transformation is used to generate surrogate keys in PowerCenter?
Sequence Generator
Expression
Aggregator
Joiner
Show Answer
✅ Correct Answer: Sequence Generator
42. What is the purpose of the **Command Task** in a PowerCenter workflow?
Execute OS/shell commands
Filter data
Sort data
Call a stored procedure
Show Answer
✅ Correct Answer: Execute OS/shell commands
43. Which transformation allows dynamic SQL queries at runtime?
SQL Transformation
Lookup
Joiner
Source Qualifier
Show Answer
✅ Correct Answer: SQL Transformation
44. What is the function of the **Error Log** in PowerCenter?
Track session failures and warnings
Store source data
Debug mappings
Encrypt data
Show Answer
✅ Correct Answer: Track session failures and warnings
45. Which transformation caches data to improve lookup performance?
Lookup Cache
Joiner
Aggregator
Router
Show Answer
✅ Correct Answer: Lookup Cache
46. What is **Partitioning** used for in PowerCenter?
Parallel processing of data
Data encryption
Metadata storage
Network routing
Show Answer
✅ Correct Answer: Parallel processing of data
47. Which file format is **not** natively supported by PowerCenter as a source/target?
Parquet
Flat File
XML
COBOL
Show Answer
✅ Correct Answer: Parquet
48. What does **DTM (Data Transformation Manager)** do?
Execute transformation logic during sessions
Manage repositories
Schedule workflows
Monitor disk space
Show Answer
✅ Correct Answer: Execute transformation logic during sessions
49. Which task type is used to send emails in a workflow?
Email Task
Command Task
Session Task
Assignment Task
Show Answer
✅ Correct Answer: Email Task
50. What is the purpose of the **Constraint-Based Loading** option?
Enforce referential integrity during loads
Improve cache performance
Encrypt target data
Skip duplicate rows
Show Answer
✅ Correct Answer: Enforce referential integrity during loads
51. Which transformation is used to handle slowly changing dimensions (SCD)?
SCD Transformation
Router
Expression
Joiner
Show Answer
✅ Correct Answer: SCD Transformation
52. What is the **Pushdown Optimization** feature used for?
Offload transformations to the source/target database
Compress data
Encrypt sessions
Cache lookup tables
Show Answer
✅ Correct Answer: Offload transformations to the source/target database
53. Which tool is used to monitor PowerCenter workflows in real-time?
Workflow Monitor
Repository Manager
Designer
Admin Console
Show Answer
✅ Correct Answer: Workflow Monitor
54. What is the purpose of the **Stop Task** in a workflow?
Terminate a running workflow
Pause a session
Skip a task
Rollback transactions
Show Answer
✅ Correct Answer: Terminate a running workflow
55. Which transformation is used to merge data from heterogeneous sources?
Joiner
Union
Router
Lookup
Show Answer
✅ Correct Answer: Joiner
56. What is the **Recovery Strategy** in PowerCenter?
Restart failed workflows from the point of failure
Backup repositories
Encrypt sessions
Validate mappings
Show Answer
✅ Correct Answer: Restart failed workflows from the point of failure
57. Which transformation is used to compare data between two pipelines?
Comparator
Expression
Aggregator
Router
Show Answer
✅ Correct Answer: Comparator
58. What is the **** syntax used for in PowerCenter?
Reference mapping variables/parameters
Call stored procedures
Define partitions
Encrypt data
Show Answer
✅ Correct Answer: Reference mapping variables/parameters
59. Which task is used to execute another workflow from a parent workflow?
Worklet
Session
Command
Email
Show Answer
✅ Correct Answer: Worklet
60. What is the **Commit Interval** setting in a session?
Number of rows processed before a commit
Session retry count
Cache size
Thread count
Show Answer
✅ Correct Answer: Number of rows processed before a commit
61. Which transformation is used to split a single row into multiple rows?
Normalizer
Router
Joiner
Aggregator
Show Answer
✅ Correct Answer: Normalizer
62. What is the **Index Cache** used for in a Lookup transformation?
Speed up lookup queries
Store source data
Encrypt results
Validate mappings
Show Answer
✅ Correct Answer: Speed up lookup queries
63. Which task type is used to execute conditional logic in a workflow?
Decision Task
Session Task
Command Task
Email Task
Show Answer
✅ Correct Answer: Decision Task
64. What is the **Tracing Level** setting used for?
Control log detail for debugging
Set partition count
Define cache size
Encrypt logs
Show Answer
✅ Correct Answer: Control log detail for debugging
65. Which transformation is used to convert rows into columns?
Pivot
Unpivot
Router
Joiner
Show Answer
✅ Correct Answer: Pivot
66. What is the **Pre-SQL** option in a session used for?
Execute SQL before loading data
Validate sources
Encrypt targets
Skip rows
Show Answer
✅ Correct Answer: Execute SQL before loading data
67. Which transformation is used to handle hierarchical data (e.g., XML/JSON)?
Hierarchical Parser
Joiner
Router
Aggregator
Show Answer
✅ Correct Answer: Hierarchical Parser
68. What is the **Target-Based Commit** option used for?
Commit data per target table
Encrypt targets
Skip duplicates
Parallelize sessions
Show Answer
✅ Correct Answer: Commit data per target table
69. Which task is used to assign values to variables in a workflow?
Assignment Task
Session Task
Command Task
Email Task
Show Answer
✅ Correct Answer: Assignment Task
70. What is the **Reject File** in a session used for?
Store rows that fail transformation rules
Cache lookup data
Log SQL queries
Backup sources
Show Answer
✅ Correct Answer: Store rows that fail transformation rules