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

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

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


Correct Option: A

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 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
  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
  1. Oracle Database

  2. Flat Files

  3. SAP/R3

  4. All of the Above


Correct Option: D

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

  1. SQL

  2. PL/SQL

  3. ABAP

  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