Question 1

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

technology platforms and products

Source
Target
Workflow
Session

Answer

Correct Option: A,B,D

Question 2

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

technology platforms and products

True
False

Answer

Correct Option: A

Question 3

Joiner transformations is used to join_______

technology platforms and products

heterogenous relational tables
files from different locations
data from the same source
All of the above
None

Answer

Correct Option: D

Question 4

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

technology platforms and products

True
False

Answer

Correct Option: B

Question 5

Lookup transformation is ______

technology platforms and products

Passive
Active
Unconnected
Connected

Answer

Correct Option: A,C,D

Question 6

The integration service matches the null values in the lookup transformation

technology platforms and products

True
False

Answer

Correct Option: B

Question 7

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

technology platforms and products

True
False

Answer

Correct Option: A

Question 8

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

technology platforms and products

integration service sorts the data
the session fails
gives unexpected results
gives the aggregated output

Answer

Correct Option: B

Question 9

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

technology platforms and products

12
11
10
1
session fails

Answer

Correct Option: B

Question 10

________lookup supports user defined default values

technology platforms and products

Unconnected
Connected
None
Both a nd b

Answer

Correct Option: B

Question 11

Reusable transformation can be made non-reusable transformation

technology platforms and products

True
False

Answer

Correct Option: B

Question 12

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

technology platforms and products

one row
all the rows
no rows
two rows

Answer

Correct Option: A

Question 13

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 _____

technology platforms and products

10,11,12,13,14
15,20,10,15,20
15,20,15,20,15
15,15,15,15,15
session fails

Answer

Correct Option: B

Question 14

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

technology platforms and products

persistent
non-persistent
both a and b
none

Answer

Correct Option: A

Question 15

The filter condition in filter transformation is case sensitive

technology platforms and products

True
False

Answer

Correct Option: B

Question 16

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

technology platforms and products

Sybase Power Designer 7.0
CA Erwin 3.0 to 3.5.2
CA AllFusion ERwin Data Modeler 4.0 SP1 to 4.1
All of the Above

Answer

Correct Option: D

Question 17

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

technology platforms and products

One-one
Many-one
One-many
No cardinality at all

Answer

Correct Option: C

Question 18

Which are the sources supported by OWB

technology platforms and products

Oracle Database
Flat Files
SAP/R3
All of the Above

Answer

Correct Option: D

Question 19

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

technology platforms and products

SQL
PL/SQL
ABAP
All of the Above

Answer

Correct Option: D

Question 20

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

technology platforms and products

No
Yes
Cant Say
Varies from case to case

Answer

Correct Option: B

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

platforms and products Online Quiz - 37

Find more quizzes from top tags