0

platforms and products Online Quiz - 37

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

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

  1. Source

  2. Target

  3. Workflow

  4. Session


Correct Option: A,B,D

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

  1. True

  2. False


Correct Option: A

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


Correct Option: D

Lookup transformation is ______

  1. Passive

  2. Active

  3. Unconnected

  4. Connected


Correct Option: A,C,D

The integration service matches the null values in the lookup transformation

  1. True

  2. False


Correct Option: B

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


Correct Option: B

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


Correct Option: A

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


Correct Option: B

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


Correct Option: A

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


Correct Option: D

Which are the sources supported by OWB

  1. Oracle Database

  2. Flat Files

  3. SAP/R3

  4. All of the Above


Correct Option: D

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

  1. No

  2. Yes

  3. Cant Say

  4. Varies from case to case


Correct Option: B
- Hide questions