What are your options to enable this combined analysis?

A new source is available containing several big tables with over 2 million rows of data. Some of
this data is needed in Oracle BI analysis, combined with existing data sources. What are your
options to enable this combined analysis?

A.
Analyze the needed data and needed granularity. If applicable create aggregation tables and
partitioned tables in the source database. Apply a type 2 customization in Informatica
PowerCenter and modify the DAC with appropriate objects. Model the BI repository with the new
data warehouse objects and enable aggregate navigation and partition navigation. Enable cross
analysis in the logical layer. Use simple requests and analyze the request performance on the new
data.

B.
Apply a type 2 customization in Informatica PowerCenter to include the necessary data
warehouse objects and modify the DAC with appropriate objects. Model the BI repository with the
new data warehouse objects and enable aggregate navigation and partition navigation.

C.
Apply a type 1 customization in Informatica PowerCenter to include the necessary data
warehouse objects and modify the DAC with appropriate objects. Model the BI repository with the
new data warehouse objects and enable aggregate navigation and partition navigation. Enable
cross-analysis in the logical layer.

D.
Analyze the needed data and needed granularity. If applicable create aggregation tables and
partitioned tables in the source database. Apply a type 1 customization in Informatica
PowerCenter and modify the DAC with appropriate objects. Model the BI repository with the new
data warehouse objects and enable aggregate navigation and partition navigation.

E.
Normalize the new data source into smaller tables and apply a type 2 customization in
Informatica PowerCenter. Apply changes in DAC to read the new source data and have execution
plans load the needed data into the data warehouse. Model the BI repository with the new data
warehouse objects and enable aggregate navigation and partition navigation. Enable crossanalysis in the logical layer.

F.
Normalize the new data source into smaller tables and apply a type 1 customization in
Informatica PowerCenter. Model the BI repository with the new data warehouse objects and
enable aggregate navigation and partition navigation. Enable cross-analysis in the logical layer.