0
Alien head

platforms and products Online Quiz - 64

Description: platforms and products Online Quiz - 64
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

Attribute dimensions can have an adverse effect on:

  1. Data Load Performance

  2. Batch Calculation Performance

  3. Retrieval Performance

  4. None of the above


Correct Option: C

Which statement is true about substitution variables?

  1. A. They are defined and stored on the server.

  2. B. They cannot store constant values.

  3. C. They are supported only in calculation scripts.

  4. They are supported only in load scripts.


Correct Option: A

Which selection is not an Output Management File component?

  1. Distribution Definition

  2. Stream Definition

  3. Output Definition

  4. Output Profile

  5. Business Document Template (BDT)


Correct Option: E

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

  1. SQL Server

  2. DB2

  3. Oracle

  4. MS Access


Correct Option: D

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

  1. True

  2. False


Correct Option: A

xDesign is part of the xPression Server Layer.

  1. True

  2. False


Correct Option: B

xAdmin and xDashboard are part of which xPression layer?

  1. Server Layer

  2. Cloud Layer

  3. Application Layer

  4. Content/Data Layer


Correct Option: C

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

Which of the following is true about Bulk Loading

  1. Recovery can be performed

  2. Can improve performance of a session that inserts a large amount of data to a db2,sysbase,oracle or MS SQL server database.

  3. Target database can perform Rollback

  4. Similar to Normal loading


Correct Option: B

Which of the following are types of lookup cache?

  1. Static cache

  2. Dynamic cache

  3. Shared cache

  4. All the above


Correct Option: D

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

  1. Normal

  2. Master outer

  3. Detail outer

  4. Full outer

  5. Full Inner


Correct Option: E

Which of the following is true about Router?

  1. Filters data on one condition

  2. Drops rows that donot meet the condition

  3. Filters the data on multiple condition

  4. Has no input and output groups


Correct Option: C

Reusable transformations can be

  1. Used multiple times in a mapping.

  2. A set of transformations that is reusable

  3. Used only in a single mapping

  4. created using mapplet designer


Correct Option: A

Two flat files be joined with Joiner Transformation

  1. True

  2. False


Correct Option: B

Which is a active transformation?

  1. Expression

  2. Lookup

  3. Normalizer

  4. XML Source Qualifier


Correct Option: C

PowerCenter Server on UNIX can connect to which database?

  1. Microsoft Access

  2. Microsoft SQL Server

  3. IBM DB2

  4. Oracle


Correct Option: C,D

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

  1. Standalone Repository

  2. Global Repository

  3. Local Repository

  4. Versioned Repository

  5. All the above


Correct Option: E

Which of the following are types of tracing levels?

  1. Normal

  2. Terse

  3. Verbose data

  4. verbose intitialization.

  5. All the above


Correct Option: E

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

  1. True

  2. False


Correct Option: B
+ View questions