Question 1

You can connect more than one group to the same target or transformation?

technology platforms and products

True
False

Answer

Correct Option: B

Question 2

Which of the following are types of tracing levels?

technology platforms and products

Normal
Terse
Verbose data
verbose intitialization.
All the above

Answer

Correct Option: E

Question 3

What type of repositories can be created using Informatica Repository Manager?

technology platforms and products

Standalone Repository
Global Repository
Local Repository
Versioned Repository
All the above

Answer

Correct Option: E

Question 4

PowerCenter Server on UNIX can connect to which database?

technology platforms and products

Microsoft Access
Microsoft SQL Server
IBM DB2
Oracle

Answer

Correct Option: C,D

Question 5

Which is a active transformation?

technology platforms and products

Expression
Lookup
Normalizer
XML Source Qualifier

Answer

Correct Option: C

Question 6

Two flat files be joined with Joiner Transformation

technology platforms and products

True
False

Answer

Correct Option: B

Question 7

Reusable transformations can be

technology platforms and products

Used multiple times in a mapping.
A set of transformations that is reusable
Used only in a single mapping
created using mapplet designer

Answer

Correct Option: A

Question 8

Which of the following is true about Router?

technology platforms and products

Filters data on one condition
Drops rows that donot meet the condition
Filters the data on multiple condition
Has no input and output groups

Answer

Correct Option: C

Question 9

Which of the following is not a type of join in a joiner transformation

technology platforms and products

Normal
Master outer
Detail outer
Full outer
Full Inner

Answer

Correct Option: E

Question 10

Which of the following are types of lookup cache?

technology platforms and products

Static cache
Dynamic cache
Shared cache
All the above

Answer

Correct Option: D

Question 11

Which of the following is true about Bulk Loading

technology platforms and products

Recovery can be performed
Can improve performance of a session that inserts a large amount of data to a db2,sysbase,oracle or MS SQL server database.
Target database can perform Rollback
Similar to Normal loading

Answer

Correct Option: B

Question 12

Dynamic content publishing transforms corporate data and valuable content into personalized communications for print, archive, email and web channels.

technology platforms and products

True
False

Answer

Correct Option: A

Question 13

xPression is a component-based Service Oriented Architecture(SOA), based on J2EE, Web Services, JMS, MS.NET and XML

technology platforms and products

True
False

Answer

Correct Option: A

Question 14

xAdmin and xDashboard are part of which xPression layer?

technology platforms and products

Server Layer
Cloud Layer
Application Layer
Content/Data Layer

Answer

Correct Option: C

Question 15

xDesign is part of the xPression Server Layer.

technology platforms and products

True
False

Answer

Correct Option: B

Question 16

xPression uses XML, RDB or XQuery file data sources for customer data.

technology platforms and products

True
False

Answer

Correct Option: A

Question 17

Which selection is not valid for hosting the Expression Database in an Enterprise installation?

technology platforms and products

SQL Server
DB2
Oracle
MS Access

Answer

Correct Option: D

Question 18

Which selection is not an Output Management File component?

technology platforms and products

Distribution Definition
Stream Definition
Output Definition
Output Profile
Business Document Template (BDT)

Answer

Correct Option: E

Question 19

Which statement is true about substitution variables?

technology platforms and products

A. They are defined and stored on the server.
B. They cannot store constant values.
C. They are supported only in calculation scripts.
They are supported only in load scripts.

Answer

Correct Option: A

Question 20

Attribute dimensions can have an adverse effect on:

technology platforms and products

Data Load Performance
Batch Calculation Performance
Retrieval Performance
None of the above

Answer

Correct Option: C

Description: platforms and products Online Quiz - 64
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: platforms and products

platforms and products Online Quiz - 64

Find more quizzes from top tags