0
Alien head

platforms and products Online Quiz - 37

Description: platforms and products Online Quiz - 37
Number of Questions: 20
Created by:
Tags: platforms and products

Can Warehouse Builder support Oracle's parallel inserts,updates and deletes ?

  1. No

  2. Yes

  3. Cant Say

  4. Varies from case to case

Answer: 2

What language does the OWB generate to extract data from sources?

  1. SQL

  2. PL/SQL

  3. ABAP

  4. All of the Above

Answer: 4

Which are the sources supported by OWB

  1. Oracle Database

  2. Flat Files

  3. SAP/R3

  4. All of the Above

Answer: 4

What is the cardinality between Runtime Repository Schema and Target schema?

  1. One-one

  2. Many-one

  3. One-many

  4. No cardinality at all

Answer: 3

Which of the CASE tools are supported by Warehouse Builder as source metadata suppliers

  1. Sybase Power Designer 7.0

  2. CA Erwin 3.0 to 3.5.2

  3. CA AllFusion ERwin Data Modeler 4.0 SP1 to 4.1

  4. All of the Above

Answer: 4

The filter condition in filter transformation is case sensitive

  1. True

  2. False

Answer: 2

If the lookup table does not change between sessions, configure the Lookup transformation to use______ lookup cache

  1. persistent

  2. non-persistent

  3. both a and b

  4. none

Answer: 1

In a sequence generator, if cycle option is checked with start value=10 ,current value=15 ,increment value=5 and end value=20, the sequence for 5 records would be _____

  1. 10,11,12,13,14

  2. 15,20,10,15,20

  3. 15,20,15,20,15

  4. 15,15,15,15,15

  5. session fails

Answer: 2

In an aggregator transformation, if we do not group values, the Integration Service returns____ for all input rows.

  1. one row

  2. all the rows

  3. no rows

  4. two rows

Answer: 1

Reusable transformation can be made non-reusable transformation

  1. True

  2. False

Answer: 2

________lookup supports user defined default values

  1. Unconnected

  2. Connected

  3. None

  4. Both a nd b

Answer: 2

In a sequence generator, if start value=10 ,current value=11 ,increment value=1 and end value=20, then the sequence would start from_______

  1. 12

  2. 11

  3. 10

  4. 1

  5. session fails

Answer: 2

If we use sorted input in an aggregator transformation and do not sort data correctly, then_________.

  1. integration service sorts the data

  2. the session fails

  3. gives unexpected results

  4. gives the aggregated output

Answer: 2

We can connect more than one output group to one target or a single input group transformation in a router transformation

  1. True

  2. False

Answer: 1

The integration service matches the null values in the lookup transformation

  1. True

  2. False

Answer: 2

Lookup transformation is ______

  1. Passive

  2. Active

  3. Unconnected

  4. Connected

Answer: 1,3,4

A normal or master outer join performs faster than a full outer or detail outer join.

  1. True

  2. False

Answer: 2

Joiner transformations is used to join_______

  1. heterogenous relational tables

  2. files from different locations

  3. data from the same source

  4. All of the above

  5. None

Answer: 4

We cannot concatenate ports from more than one transformation into the Filter transformation

  1. True

  2. False

Answer: 1

We can create/drop the indexes/tables at the________ level

  1. Source

  2. Target

  3. Workflow

  4. Session

Answer: 1,2,4
+ View questions