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

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

Joiner transformations is used to join_______

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

Lookup transformation is ______

The integration service matches the null values in the lookup transformation

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

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

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

________lookup supports user defined default values

Reusable transformation can be made non-reusable transformation

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

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 _____

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

The filter condition in filter transformation is case sensitive

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

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

Which are the sources supported by OWB

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

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