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

Attribute dimensions can have an adverse effect on:

  1. Data Load Performance

  2. Batch Calculation Performance

  3. Retrieval Performance

  4. None of the above

Answer: 3

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.

Answer: 1

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)

Answer: 5

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

  1. SQL Server

  2. DB2

  3. Oracle

  4. MS Access

Answer: 4

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

  1. True

  2. False

Answer: 1

xDesign is part of the xPression Server Layer.

  1. True

  2. False

Answer: 2

xAdmin and xDashboard are part of which xPression layer?

  1. Server Layer

  2. Cloud Layer

  3. Application Layer

  4. Content/Data Layer

Answer: 3

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

  1. True

  2. False

Answer: 1

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

  1. True

  2. False

Answer: 1

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

Answer: 2

Which of the following are types of lookup cache?

  1. Static cache

  2. Dynamic cache

  3. Shared cache

  4. All the above

Answer: 4

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

Answer: 5

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

Answer: 3

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

Answer: 1

Two flat files be joined with Joiner Transformation

  1. True

  2. False

Answer: 2

Which is a active transformation?

  1. Expression

  2. Lookup

  3. Normalizer

  4. XML Source Qualifier

Answer: 3

PowerCenter Server on UNIX can connect to which database?

  1. Microsoft Access

  2. Microsoft SQL Server

  3. IBM DB2

  4. Oracle

Answer: 3,4

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

Answer: 5

Which of the following are types of tracing levels?

  1. Normal

  2. Terse

  3. Verbose data

  4. verbose intitialization.

  5. All the above

Answer: 5

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

  1. True

  2. False

Answer: 2
+ View questions