0

platforms and products Online Quiz - 58

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

Style Sheet templates are stored in which class

  1. RULE-FILE-STYLE

  2. RULE-FILE-CSS

  3. RULE-FILE-TEXT

  4. RULE-FILE-BINARY


Correct Option: C
  1. 32 characters

  2. 64 characters

  3. 128 characters

  4. No length restriction


Correct Option: B

ETL lifecycle includes which of the following task-type?

  1. Data Validation

  2. Data Mining

  3. Report Generation

  4. Data Modeling


Correct Option: A
  1. Validation of all negative scenarios like handling of incorrect data type

  2. Testing the boundaries of each field to find any limitations

  3. Job not to be aborted at any cause - all abort scenarios must be handled in the code

  4. Cleansing of obvious data for any anomalies (even if its not specified in requirements)

  5. None of the above


Correct Option: A,B
  1. Start a Workflow

  2. Check Session Logs

  3. Delete Informatica Code Components

  4. Check Workflow status


Correct Option: C
  1. Rounding decimal values to Integers

  2. Removing special characters from a Text field

  3. Defining Primary Key constraint on a Table

  4. Assigning a default value to a field.


Correct Option: C

Identify the Component that cannot be created in Powercenter's Mapping Designer

  1. Mapplet

  2. Transformations

  3. Mapping

  4. Task


Correct Option: D

Filter Transformation is better than Router Transformation to direct the data to multiple output groups

  1. True

  2. False


Correct Option: B

Enterprise Information Integration is described by

  1. the capability to access data from any source, regardless of format or system

  2. The ability to access data without proper authorization

  3. The ability to store data in one source without it being accessible to other systems

  4. The ability to manipulate data remotely


Correct Option: A

Informatica PowerCenter can read data from an MS SQL database?

  1. True

  2. False


Correct Option: B

Which of the following is a Passive Transformation

  1. Aggregator

  2. Expression

  3. Normalizer

  4. Filter


Correct Option: B
  1. Reducing the number of transformations

  2. Using conditional filters

  3. Droping Indexes & Key Constraints before loading

  4. Using Multi - pass reads from source


Correct Option: A,B,C
  1. High performance decision support environments

  2. Master Data Management hubs

  3. Online Transaction processing

  4. All the above


Correct Option: A,B

Xcelsius Enterprise was originally introduced by

  1. SAP

  2. BO

  3. Infommersion

  4. All the Above


Correct Option: C

Xcelsius Engage provides end users with access to up-to-the-minute company data in a simple and actionable interface.

  1. True

  2. False


Correct Option: A

Which among the following are possible data sources for Xcelsius Engage?

  1. Microsoft Excel

  2. XML databases

  3. SOAP-based Web services

  4. All the above


Correct Option: D
- Hide questions