1.

In powercenter informatica AES_ENCRYPT fucntion returns data in

string format

binary format

number format

Odate format

ChatGPT
In PowerCenter Informatica, the AES_ENCRYPT function returns data in binary format.
2. When using an ORDER BY clause in a Source Qualifier or making use of a Sorter
transformation, what transformation attribute can be checked with in the Aggregator or
Joiner transformations to make them more efficient?

Sorted Output

Sorted Input

Sorted Data

Sorted information

ChatGPT
When using an ORDER BY clause in a Source Qualifier or Sorter transformation, the
transformation attribute that can be checked within the Aggregator or Joiner
transformations to make them more efficient is "Sorted Input".
3. ---is example of subscription-based reference data

Customer ratings

Name and Address

Credit ratings

All of the options

None of the options

ChatGPT
An example of subscription-based reference data is "Credit ratings".
4. LAST function returns

the last character of a string

the last NOT NULL value in the selected port

the last NULL value for a selected port

Any of the above choices is true

ChatGPT
The LAST function in Informatica returns the last NOT NULL value in the selected port.
5. Which of the following ports can have aggregate functions?
V

I/o

ChatGPT
The port "I/o" can have aggregate functions.
6. The following function converts separate input values to a date and time

IS_DATE

MAKE_DATE_TIME
TO_CHAR

TO_DATE

ChatGPT
The function that converts separate input values to a date and time is
MAKE_DATE_TIME.
7. Which of the following is an executable component in PowerCenter 6.x onwards?

Session
Batch

Worklet

Workflow

ChatGPT
In PowerCenter 6.x onwards, an executable component is a "Workflow".
8. Which of the following statements is True?

A Joiner Transformation can be used to join more than two data pipelines

A Joiner transformation can be used to join only two data pipelines

A Joiner transformation can be used for joining any number of data pipelines

None of the options statement is true

All of the options statements are true

ChatGPT
The true statement is: "A Joiner transformation can be used to join only two data
pipelines."
9. PowerCenter license is based on select that all apply

Number of CPUs
Amount of Memory

Operating System

Processor bits (32.64)

Number of users

ChatGPT
PowerCenter license is based on the following:

Number of CPUs
Amount of Memory
Processor bits (32/64)

10. SYSDATE returns

Othe current date and time on the machine hosting the Integration Service

the current datetime of the machine where Designer is installed

the datetime on the machine where Repository is hosted

the datetime of the node on which Repository Service is running

ChatGPT
SYSDATE returns the current date and time on the machine hosting the Integration
Service.

11. If you are owner of a folder, what other privilege will be required to copy objects
from other folders to your folder

O Read privilege on Source Folder

Read-write privileges on your folder

Admin privileges on both the folders

No additional privilege is required

ChatGPT
To copy objects from other folders to your folder, you would need read privilege on the
source folder and read-write privileges on your folder. So, the correct option is: "Read
privilege on Source Folder and Read-write privileges on your folder."

12. Data cache of Aggregator transformation sums up column sizes of

Non group by I/O ports

Local Variable ports

Ports containing non-aggregate expressions

All ports apart from Group By ports

ChatGPT
The data cache of the Aggregator transformation sums up the column sizes of "Non
group by I/O ports."

13. NULL is equivalent to empty string

O TRUE

OFALSE

ChatGPT
FALSE

14. A user has completed a Delete Repository operation. It is later discovered that some
of the metadata objects in that deleted repository should have been copied to another
repository prior to the deletion. What, if anything, can be done to recover the obje

Nothing can be done because the actual database tables have been deleted (dropped).

Until the Administrator re-starts the repository server, the repository has only been
removed from the server cache. Perform a Repository Restore operation on the deleted
repository to recover all objects.

A user with Administrator or Super User privileges must go to a client machine that still
has the deleted repository in the local repository list, and perform a Restore Repository
operation.
O The objects can be recovered only if they are part of a Deployment Group within a
Global Data Repository. This is why it is recommended that critical objects be stored
within a GDR.

ChatGPT
Nothing can be done because the actual database tables have been deleted (dropped).
15. Ports in Normalizer tab can only be edited in Normalizer transformation.

O TRUE

O FALSE

ChatGPT
FALSE

16.:If the current year is between 50 and 99 (such as 1998) and the source string year is
between 0 and 49, in RR format

the Integration Service returns the next century plus the two-digit year from the source
string.

the Integration Service returns the current century plus the specified two-digit year.

the Integration Service can return anything

ChatGPT
If the current year is between 50 and 99 and the source string year is between 0 and 49, in
RR format, the Integration Service returns the next century plus the two-digit year from
the source string.
17. What is the difference between the system variables $$$SessStartTime and
SESSSTARTTIME?

$$$SessStartTime returns the session start time as a string, and SESSSTARTTIME

returns the session start time as a date/time

$$$SessStartTime returns the session start time as a date / time, and SESSSTARTTIME
returns the session start time as a string.

Both will return the session start time as a string, but only $$$SessStartTime can be used
as a mapping parameter.

There is no difference in practice. Either can be used to return the session start time in
date/time format.

ChatGPT
The difference between the system variables $$$SessStartTime and SESSSTARTTIME
is:

So, the correct option is: "$$$SessStartTime returns the session start time as a string, and
SESSSTARTTIME returns the session start time as a date/time."

18. It is possible for an Administrator to unshare a Shared folder

O TRUE

O FALSE
ChatGPT
TRUE

19. Which data sources can be read via a Source Qualifier?

Relational tables

Flat files

Relational and Flat Files

Cobol copybooks

ChatGPT
The data sources that can be read via a Source Qualifier in Informatica PowerCenter
include:

Relational tables
Flat files
So, the correct option is: Relational and Flat Files.

20. Which components are required to run a debug session?

O Designer

Designer and Workflow Manager

Desinger and running Integration Service

Designer, Workflow Manager and Integration Service

ChatGPT
To run a debug session in Informatica PowerCenter, you need:

Designer
Workflow Manager
Running Integration Service
So, the correct option is: Designer, Workflow Manager, and Running Integration Service.

21. PowerCenter transformation language supports which comments specifiers?

Select that all apply

/**/

--

! --

//

ChatGPT
PowerCenter Transformation Language supports the following comment specifiers:

/**/
--
//

22. What happens if Sorted Input is checked in Aggregator and the transformation
receives unsorted data?

The Integration Service sorts data as per group by ports

Incorrect data is passed to downstream transformations

The session fails

ChatGPT
If "Sorted Input" is checked in the Aggregator transformation, and the transformation
receives unsorted data, the session might produce incorrect results or behave
unexpectedly. However, the session itself does not fail automatically. It's essential to
ensure that the data is sorted properly before it reaches the Aggregator transformation to
avoid incorrect aggregation results.

23. Which transformation can be used to read directly from Web Site?

XML Parser

Source Qualifier

HTTP transformation

XML Generator
ChatGPT
The transformation that can be used to read directly from a website in Informatica
PowerCenter is the "HTTP transformation".

24. Informatica External procedure is deployed as-----in Unix environment

Shell script

shared library

folder

Any of the above choices are true

ChatGPT
Informatica External Procedure is deployed as a "shared library" in a Unix environment.

25. For following transformations, processing is pushed only to the target database with
Pushdown optimization. Select that all apply.

Update Strategy

Expression

Lookup

Target Definitions
ChatGPT
The transformations for which processing is pushed only to the target database with
Pushdown optimization are:

Update Strategy
Target Definitions

26. A user desires to reference a Custom transformation in an expression (Unconnected

Mode). Select the statement below that is true.

The Custom transformation must be passive.

The Custom transformation must have no more than one output group.

The Custom transformation must be passive and it must have no more than one output
group.

This functionality is not supported under any circumstances.

ChatGPT
The correct statement is:

"The Custom transformation must be passive and it must have no more than one output
group."

27. CUME function is available in

Designer
Repository Manger

Workflow Manager

Workflow Monitor

ChatGPT
The CUME function is available in Designer.

28. Which of the following can be utilized as Group By ports in an Aggregator? Select
that all apply.

I/0

ChatGPT
In an Aggregator transformation, the following can be utilized as Group By ports:

Input/output ports (I/O)

Output ports (O)
Input ports (I)
So, the options are: I/O, O, and I.

29. For following transformations, processing is pushed only to the Source Database with
Pushdown optimization. Select that all apply.

Aggregator

Lookup

Expression

Joiner

Filter

ChatGPT
For the following transformations, processing is pushed only to the Source Database with
Pushdown optimization:

Lookup
Filter

30. Which are the different authentication modes that can be defined for PowerCenter
client authentication?

Only PowerCenter Default authentication

PowerCenter default authentication and LDAP Authentication

PowerCenter default authentication and Directory Service Authentication

PowerCenter default authentication and Windows Authentication

Any third party authentication tool can be supported

ChatGPT
The different authentication modes that can be defined for PowerCenter client
authentication include:

PowerCenter Default authentication

LDAP Authentication
Directory Service Authentication
Windows Authentication
So, the correct option is: PowerCenter default authentication and LDAP Authentication.

31. Metadata can be in language in PowerCenter 8.x repository

English

French

Dutch

All of the options

ChatGPT
In PowerCenter 8.x repository, metadata can be stored in multiple languages including
English, French, and Dutch.

So, the correct option is: All of the options.

32. NULL||'ABC' returns

Option 1: NULL

Option 2: ABC

Option 3: NULL||'ABC'

Option 4: abc

ChatGPT
NULL||'ABC' returns Option 2: ABC.

33. NULL and TRUE evaluates to

NULL

TRUE

FALSE
Any value

ChatGPT
NULL and TRUE evaluates to NULL.

34. IN () functions returns a NULL when

Input value is not in LOV

Input value is one of the values in LOV

Input value matches multiple values in LOV

Input value is a NULL

ChatGPT
The IN () function returns NULL when the input value is not in the list of values (LOV).

35. Data Quality workbench and Data Quality Integration are packaged with which
PowerCenter option?

High Availability

Multilingual Support

Team Based Development

Data Cleanse and Match

ChatGPT
Data Quality Workbench and Data Quality Integration are packaged with the "Data
Cleanse and Match" option in PowerCenter.

36. MX views provide a set of relational views that allow easy SQL access to the
PowerCenter Metadata Repository

TRUE

FALSE

ChatGPT
TRUE

37. Which is the default App server that gets installed with Data Analyzer?

Jboss

IBM Web Sphere

WebLogic

Apache Tomcat

ChatGPT
The default App server that gets installed with Data Analyzer is Jboss. .
38. LN function returns

the number of characters in a string.

the natural logarithm of a numeric value.

log of a number to base 10

number of spaces

ChatGPT
The LN function returns the natural logarithm of a numeric value.

39. Which folder property determines if folder is a shared folder

Is shared

Sharable

Allow shortcuts

All of the options options

None of the options options

ChatGPT
The folder property that determines if a folder is a shared folder is "Is shared."

40. How many schema's are required during PowerCenter installation?

01

02

03

Any number

ChatGPT
During PowerCenter installation, typically two schemas are required:

Repository schema: This schema is used to store repository metadata.

Domain schema: This schema is used to store domain configuration information.
So, the correct answer is: 02

41. What is dynamic partitioning in PowerCenter 8.x? Select that all apply

Number of session partitions are defined dynamically by Integration Service

Maps to Hash partitioning in source system

Maps to Key-Range partitioning in target system

Number of session partitions depends on Source database partitions or number of nodes
in grid

ChatGPT
In PowerCenter 8.x, dynamic partitioning refers to the following:

Number of session partitions are defined dynamically by Integration Service.

Number of session partitions depends on Source database partitions or number of nodes
in grid.
So, the correct options are:

Number of session partitions are defined dynamically by Integration Service

Number of session partitions depends on Source database partitions or number of nodes
in grid

42. The Integration Service evaluates operators in which precedence?

String operators -> Arithmetic operators -> Logical operators -> Comparison operators

Arithmetic operators -> String operators -> Comparison operators -> Logical operators

Comparison operators -> Arithmetic operators -> String operators -> Logical operators

String operators -> Logical operators -> Arithmetic operators -> Comparison operators

ChatGPT
The Integration Service evaluates operators in the following precedence:
Arithmetic operators -> String operators -> Comparison operators -> Logical operators

So, the correct option is: Arithmetic operators -> String operators -> Comparison
operators -> Logical operators

43. NULL and FALSE evaluates to

NULL

TRUE

FALSE

Any value

ChatGPT
NULL and FALSE evaluates to FALSE.

44. What does UTF stand for?

Universal Transfer Format

Universal Transformation File

Universal Transfer function

Universal Transformation Format

ChatGPT
UTF stands for "Universal Transformation Format."

45. ADD_TO_DATE accepts positive and negative integer values

O TRUE

O FALSE

ChatGPT
TRUE
46. What is the purpose of the Output window?

To allow the user to view and reclaim objects that have been deleted.

To display the status of running and completed Workflows.

To allow the user to view the data that is being written to the target.

To display detailed status messages.

ChatGPT
The purpose of the Output window in Informatica PowerCenter is to display detailed
status messages.

47. The following function converts a date to a string.

IS_DATE

MAKE_DATE_TIME

TO_CHAR

TO_DATE

ChatGPT
The function that converts a date to a string in Informatica PowerCenter is TO_CHAR.

48. What is the difference between a mapping parameter and a mapping variable?

O A parameter value can change throughout a Session Task run, and a mapping variable
value remains constant.

A parameter value remains constant throughout a Session Task run, and a mapping
variable value can change.

A parameter value must be read from a flat file, and a mapping variable value must be
recalculated with an expression for each row.

A mapping variable value must be read from a flat file, and a parameter value must be
recalculated with an expression for each row.

ChatGPT
The difference between a mapping parameter and a mapping variable is:
A parameter value remains constant throughout a Session Task run, and a mapping
variable value can change.
So, the correct option is: "A parameter value remains constant throughout a Session Task
run, and a mapping variable value can change."

49. Which activities below can be performed using Designer?

Create Folder, run debugger, import sources and targets

Create mappings, validate reusable transformations, define deployement groups

Create mappings, define parameters and variables, run debugger

Define labels, search for objects, run debugger

ChatGPT
The activities that can be performed using Designer include:

Create mappings
Define parameters and variables
Run debugger
So, the correct option is: "Create mappings, define parameters and variables, run
debugger."

50. SQL transformation can run in... Select that all apply.

Script mode
Query mode

Default mode

Standard mode

ChatGPT
SQL transformation can run in:

Script mode
Query mode

51. functions cannot be used in UDF

Conversion functions

Character Functions

Aggregate Function

Date Functions

ChatGPT
Functions that cannot be used in a User-Defined Function (UDF) within Informatica
PowerCenter include:
Aggregate Functions

52. Domain functions performed by Service manager include.. Select that all apply.

Domain Configuration

Authentication

Node configuration

Alerts

Authorization

ChatGPT
Domain functions performed by the Service Manager in Informatica PowerCenter
include:

Domain Configuration
Node Configuration
Authentication
Alerts
Authorization

53. What is the former name of Metadata Manager product?

PowerGlue
Metadata Manager

SuperGlue

Metadata Consolidator

ChatGPT
The former name of the Metadata Manager product was "SuperGlue."

54. The string literals in expression editor should be included in

O Single quotes

Double quotes

Square Brackets

Curly Brackets

None

ChatGPT
The string literals in expression editor should be included in single quotes.

55. What is a service manager? Select that all apply.

Service in Window's environment

Deamon process in Unix environment

A physical component that is installed during PowerCenter installation

A service instance

Process thread

ChatGPT
A service manager in the context of Informatica PowerCenter can be:

A physical component that is installed during PowerCenter installation

A service instance

56. Informatica External procedure is deployed as in Windows environment

DLL

Driver

Utility

Executable

ChatGPT
Informatica External Procedure is deployed as a DLL (Dynamic Link Library) in a
Windows environment.

57. How can High Availability feature be enabled in PowerCenter 8.x?

By creating backup services

By creating primary and secondary nodes

By assigning multiple services

By creating grid

ChatGPT
High Availability feature in PowerCenter 8.x can be enabled by creating primary and
secondary nodes.

58. PowerCenter was called -------in INFA versions 4.x and 5.x for small deployments

O DataMart

PowerMart

Decision Mart

None of the options

All of the options

ChatGPT
PowerCenter was called "PowerMart" in INFA versions 4.x and 5.x for small
deployments.

59. Which of the following can be utilized for capturing incremental data for
Aggregation? Select that all apply.

Filter

Stored Procedure

Mapping Variables

Source Qualifier

ChatGPT
For capturing incremental data for Aggregation in Informatica PowerCenter, the
following can be utilized:

Filter
Mapping Variables
Source Qualifier
60. Different lookup transformations with different output ports can share a single cache
file
TRUE

FALSE

ChatGPT
TRUE