Tag: databases

Questions Related to databases

which is an passive transformation
technology databases

  1. filter

  2. aggregator

  3. expression

  4. none

Show answer
Correct Option: C

which is an unconnected transformation

technology databases

  1. look up

  2. stored procedure

  3. both

  4. none

Show answer
Correct Option: C

How many transformations are there

technology databases

  1. 1

  2. 2

  3. 3

  4. 10

Show answer
Correct Option: B

Datawarehouse is used to load

technology databases

  1. operational data

  2. historical data

  3. both

  4. none

Show answer
Correct Option: B

which one is reporting tool

technology databases

  1. Informatica

  2. Datastage

  3. Cognos

  4. Abnitio

Show answer
Correct Option: C

how to load data in target using primary and foreign keys through?
technology databases

  1. constraint based load

  2. e-mail

  3. target load plan

  4. none

Show answer
Correct Option: A

mapping consist of......?

technology databases

  1. source

  2. target

  3. transformations

  4. All the above

Show answer
Correct Option: D

how many transformations are there?

technology databases

  1. 2

  2. 3

  3. 10

  4. 25

Show answer
Correct Option: A

what is datawarehousing?

technology databases

  1. programming language

  2. scripting language

  3. database

  4. operating system

Show answer
Correct Option: C

what is datamart?

technology databases

  1. an variable

  2. subset of datawarehouse

  3. both

  4. none

Show answer
Correct Option: B