which is an passive transformation
filter
aggregator
expression
none
which is an unconnected transformation
look up
stored procedure
both
How many transformations are there
1
2
3
10
Datawarehouse is used to load
operational data
historical data
which one is reporting tool
Informatica
Datastage
Cognos
Abnitio
how to load data in target using primary and foreign keys through?
constraint based load
e-mail
target load plan
mapping consist of......?
source
target
transformations
All the above
how many transformations are there?
25
what is datawarehousing?
programming language
scripting language
database
operating system
what is datamart?
an variable
subset of datawarehouse