Friday, November 9, 2012

Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1


Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

After upgrade to bundle patch set 11.1.1.6.2 The new SQL generated by the .RPD file aggregates data incorrectly.

Solution

1)      Take a copy of the 11.1.1.6.0 .RPD file (repository version 318)
2)      Open the 11.1.1.6.2 version of the Admin tool  (repository version 320)
3)      Open the 11.1.1.6.0 version of the .RPD file with the 11.1.1.6.2 version of the Admin tool.
4)      Save the .RPD file and upload it.


Note that opening a copy of the .RPD file from the upgraded (11.1.1.6.2) OBIEE server will not work.  The version of that RPD is already 11.1.1.6.2, so the 11.1.1.6.2 Admin tool will not “upgrade” it to the current version.  You need to use the 11.1.1.6.0 RPD.

Reference:

Till next time...

Error while generate DAC parameters



Issue:

Error while generate DAC parameters

BIDEV Financial Analytics

MESSAGE:::No physical folder information found for SILOS_DEV
EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.design(ExecutionPlanDesigner.java:1322)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:169)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:119)
com.siebel.analytics.etl.client.view.table.EtlDefnTable.doOperation(EtlDefnTable.java:169)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

Solution:

Go to Tools->Seed Data->Task Physical Folders -> add new physical folder, name it with SILOS_DEV












Till next time...

OBIEE 11.1.1.6.2 BP1 Patchset is released


OBIEE 11.1.1.6.2 BP1 is now available on My Oracle Support.

The Oracle Business Intelligence 11.1.1.6.2 BP1 patchset comprises of the below patches: 
1.     14223977 Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer
2.     14226980 Patch 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions
3.     13960955 Patch 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher
4.     14226993 Patch 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components
5.     14228505 Patch 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
6.     13867143 Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence
7.     14142868 Patch 11.1.1.6.2 BP1 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

Note
•    The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. 
•    The instructions to apply the above patches are identical, and are contained in the Readme file for Patch 14223977.






Thursday, September 27, 2012

Set Numbers of row per page


Some of peoples maybe ask this question why by default OBIEE only show 25 rows per page for table or pivot. Maybe some of you want to change number of this row as you needed. This step show you how to do that
At the report level, edited the table view property set number of Rows Per Page you want to show. For example you may want to show 100 rows per page, then set on Rows per Page to value 100
 
 
 











Till Next Time

Saturday, July 21, 2012

Export / Import Repository metadata

Export Repository metadata
Tools->DAC Repository Management -> Export
Export file C:\Oraclebi\DAC\bifoundation\dac\export




Import Repository metadata
Tools->DAC Repository Management -> Import

















Till next time

How to format "Percent of" in OBIEE pivot-tables

Sometime you want to set more then a digit for percent value. How to do that in OBIEE 11G. Here are steps to perform that.

Here is sample of report that we want to set 2 digit of decimal value













Go to advanced tab












Copy xml code to text editor then look for this xml code
<saw:dataFormat xsi:type="saw:percent" minDigits="1" maxDigits="1" scale="2"/></saw:formatSpec></saw:displayFormat></saw:showAs>

Replace minDigits and maxDigits value

<saw:dataFormat xsi:type="saw:percent" minDigits="2" maxDigits="2" scale="2"/></saw:formatSpec></saw:displayFormat></saw:showAs>
If you want to set 2 digit for decimal replace with above code.
Here is the result

Till next time





Sunday, June 3, 2012

Oracle 1z0-525: Practice Exam Oracle Business Intelligence Applications 7 for ERP Essentials


QUESTION NO: 1

What is the default location where parameter files are created by DAC?

A. $DAC_HOME\Informatica\server\parameters

B. $DAC_HOME\Informatica\parameters

C. $DAC_HOME\parameters

D. $lNFA_HOME\server\infa_shared\BWParam

Answer: B

QUESTION NO: 2

The webcat structure, along with various other presentation parameters are stored in:

A. DBFeatures.ini

B. Instanceconfig.xml

C. NQSConfig.ini

D. Repository File (.rpd)

Answer: D

QUESTION NO: 3

A large insurance company ABC-Safe uses PeopleSoft and Hyperion Planning & Budgeting for

Financial Analytics and a third-party software package for HR Compensation. ABC-Safe wants to

have a consolidated picture of its finances and compensation packages. What would you advise?

A. Immediately enhance the existing Oracle BI Financial Application with HR analytics.

B. Perform a fit-gap analysis on the usability of the ETL for HR analytics and cross functionality

with Financial Applications and present a business case for extending the Oracle BI Applications

environment with Oracle BI HR analytics or enhance the existing BI applications environment with

HR data by building the ETL, enhance the BI repository, Reports& Dashboards, security and other

needed elements.

C. Oracle BI applications cannot be enhanced by data from third-party software packages.

D. Offer implementing Oracle BI HR Analytics, including a calculation for reusing prebuilt ETL

using the Universal connector.

E. Offer implementing Oracle BI Standard Edition One, including a Compensation warehouse

setup in Warehouse Builder.
Answer: B

QUESTION NO: 4

Which three variable types does the BI Applications data model support for specifying currencies?

A. Document

B. Local

C. Global

D. Override

Answer: A,B,C

QUESTION NO: 5

Which condition results in a source record being neglected during incremental load?

A. INTIAL_UPDATE_DATE >= LAST_EXTRACT_DATE

B. LAST_UPDATE_DATE >= LAST_EXTRACT_DATE

C. LAST_UPDATE_DATE > = INITIAL_EXTRACT_DATE

D. LAST_UPDATE DATE <= LAST EXTRACT DATE

Answer: D

QUESTION NO: 6

How can you be sure to access a specific data source in a default Oracle BI Applications

installation for users working from a client machine? Assume that log level 2 has been enabled.

A. With log level 2 or higher enabled in the NQsConfig.ini, you can check the SQL from the query

log of a specific Answers request. Read the SQL and check the connection pool(s) used and the

data source name(s).

B. The only data source in a standard BI Applications installation is the data warehouse. This

source is defined in DAC in the Setup View under Physical Data Sources. You can also check the

(native) connection credentials.
C. Sources can range from data warehouse to OLTP systems. Their connections are named in

connection pools in the BI repository. Using these connection names you can check the (native)

connection credentials.

D. All physical connections are defined in Informatica Powercenter Repository Manager. Log in

and check all connection credentials.

E. Users can log in to Answers, the BI repository, DAC or Informatica to check connection

credentials and data source names.

Answer: C

QUESTION NO: 7

Which three calendar types are supported by BI Applications 7.9.6 release?

A. Enterprise

B. 13 Period, 4-4-5

C. Fiscal and Gregorian

D. 15 Period

Answer: A,B,C

QUESTION NO: 8

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.

Answer: A

QUESTION NO: 9

Which is true regarding the location of Informatics PowerCenter client tools installation?

A. the client tools should be installed on the same machine as the transactional database.

B. the client tools should be installed on the same machine as the DAC Server.

C. the client tools should be installed on the same machine as the OBAW database.

D. the client tools should be installed on the same machine as the DAC client.

Answer: D

QUESTION NO: 10

The universal adapter in Informatica, is used to load data from what two sources?

A. EBS

B. JD Edwards

C. Legacy OLTP Systems

D. Non Oracle Sources

Answer: A,C

QUESTION NO: 11

Which is not a customized fact or dimension table?

A. wc_xxx_f

B. w_xxx_f

C. wc_xxx_fs

D. wc_xxx_a

Answer: B


QUESTION NO: 12

Which task level parameter(s) control(s) the granularity of data in Aggregate tables?

A. TIME_GRAIN only

B. GRAIN_LEVEL only

C. GRAIN only

D. TIME_GRAIN or GRAIN

Answer: A

QUESTION NO: 13

What is a DTM in Informatica?

A. Data Transmission Manager

B. Data Transmission Mode

C. Data Transformation Manager

D. Data Transformation Mode

Answer: C

QUESTION NO: 14

The Green Factory (a national agricultural organization with one office for IT support and

consisting of 20 farmers, 2 dairy producing factories, and a vegetables and flowers Auction)

wishes you to implement Sales Analytics and enable all members to benefit most from the Out of

the Box materials. What would you advise?

A. Analyze expected use and calculate capacity. Organize architecture according to the calculated

capacity and implement Oracle BI Sales Analytics centrally. Define user groups and apply object

security. Define different profiles in Delivers and schedule iBots to provide users with the data they

need. Arrange meetings for quick user acceptance.

B. Organize architecture and directly implement Oracle BI Sales Analytics centrally. Define one

user group and schedule iBots to provide this group with the data it needs. Arrange meetings for

quick user acceptance.

C. As Answer A, but check and reuse existing user groups

D. As Answer A, but installed de-centrally

E. As Answer B, but installed de-centrally

Answer: C

QUESTION NO: 15

Which two statements are true?

A. It is recommended to co-locate the DAC Client with the Power Center Client Tool on the same

machine.

B. It is recommended to co-locate the DAC Server and Power Center Server on the same

machine.

C. It is recommended to co-locate DAC Server, Informatica Server, and the Database Server on

the same machine.

D. It is recommended to co-locate the DAC Server, Informatica Server, and BI Server on the same

machine.

Answer: A,B

QUESTION NO: 16

Which csv file contains grouping information of natural accounts?

A. file_group_acct_codes . csv

B. file_group_acct_names.csv

C. file_glacct_segment_config.csv

D. file_grpact fstmt.csv

Answer: B

QUESTION NO: 17

Which two are mandatory pre-installation tasks for Informatica Power Center Client installation?

A. Pre-installation of Informatica Server

B. Creation of Informatica repository

C. Creation of ODBC Database Connections

D. Pre-installation of Data Warehouse Administration console

E. Pre-installation of Oracle Business Intelligence Enterprise Edition

Answer: C,E

QUESTION NO: 18

Web object security can be enforced at which three levels?

A. Report column

B. Report

C. Dashboard

D. Dashboard page

Answer: A,B,C

QUESTION NO: 19

What is the purpose of csv files under the SrcFiles folder in Informatica server home?

A. They are used to store Informatica parameters.

B. They are the source for enterprise-dependent data, required for loading certain dimensions.

C. They are used to hold data extracted during ETL processes.

D. They are used for customization.

QUESTION NO: 20

During what phase does DAC calculate the sequence of the tasks listed under the selected

subject area?

A. when you 'synchronize" the tasks

B. when you "generate parameters" for an execution plan

C. when you "assemble" the subject area

D. when you "build" the execution plan

Answer: C

QUESTION NO: 21

Data Warehouse Administration Console (DAC) interacts with Informatica Server using what

command?

A. PMCMD

B. PMREP

C. infacmd

D. infasetup

Answer: D

QUESTION NO: 22

Considering BIEE is seamlessly integrated with source application, identify three ways in which

user credentials can be passed on to BIEE from the source application login.

A. Cookies

B. Server variables

C. http header / url

D. Use of shared memory

Answer: A,B,C

QUESTION NO: 23

What is the significance of Configuration tags in Oracle DAC?

A. It controls the inclusion of tasks in a subject area.

B. It controls the parameters generated by DAC.

C. It controls the OS configuration parameters required for functioning of DAC

D. It controls the configuring of the source and target database schemas.

Answer: A

QUESTION NO: 24

During which phase of the Oracle BI Applications project flow are decision makers interviewed for

the first time?

A. Design

B. Build

C. Define

D. Validate

Answer: A

QUESTION NO: 25

Where is the appropriate JDBC Driver installed to enable DAC to connect to the database?

A. DAC/bin

B. DAC/lib

C. DAC/drivers

D. DAC/log

Answer: B

QUESTION NO: 26

Which three tasks is DAC capable of handling Data Warehouse connection Information?

A. Managing an Informatica workflow.

B. Executive an external program.

C. Running a SQL file.

D. Performing a database Backup/Restore.

Answer: A,C,D

QUESTION NO: 27

Which utility reads the contents of the .ctl file and generates the SQL statements to create and

alter tables?

A. ddlimp

B. cryptotools

C. pmrep

D. pmcmd

Answer: A

QUESTION NO: 28

How does DAC know the source OLTP and target Data Warehouse connection Information?

A. This information is given in the Physical Data sources tab in DAC client.

B. This information is given in two flat files, file_source.csv and file_target.csv.

C. It fetches this information from Informatica.

D. DAC doesn’t require knowing this information. However ft is required to give this information in

Answer: A

QUESTION NO: 29

To enable SSO integration of the Source EBS Application with BIEE which file do you need to

configure?

A. NQSConfig.ini

B. credentialstore.xml

C. instanceconfig.xml

D. isapiconfig.xml

Answer: C

QUESTION NO: 30

Which variable is changed for Target Warehouse in the OBIEE repository while promoting the

code to the new environment?

A. TARGET_DB

B. OLTP_DSN

C. DW_CONNECTION

D. OLAP_DSN

Answer: B

QUESTION NO: 31




Which is the right sequence of a typical Informatica Type 1 Customization?

i) Extend Staging and target Database table to accommodate new column.

ii) Copy appropriate Informatica mapping and workflow to Informatica Custom folder.

iii) Modify the existing Informatica mapping workflow to accommodate new columns.

iv) Modify DAC with the necessary change.

A. i, ii, in, iv
B. i, iii, ii, iv
C. iii, ii, i, iv
D. ii, i, iii, iv
Answer: B
QUESTION NO: 32
What techniques would you use to promote Oracle BI Applications materials to a new environment

after ail environments have been set up initially?

A. Copy the BI Presentation catalog and BI repository into the new environment, create a db dump

for the DAC repository and Informatics Repository and Data Warehouse. Load these into the new

environment.

B. Copy the BI Presentation catalog and BI repository into the new environment, create a db dump

for the DAC repository and load this into the new environment. Restore connections between

DAC, Informatica, the Warehouse and its source(s).

C. Copy the BI Presentation catalog and BI repository into the new environment. Check

connections between DAC, Informatica, the Warehouse and its source(s).

D. Copy the BI repository into the new environment, create a db dump for the DAC repository and

Warehouse and load these into the new environment. Check connections between DAC,

Informatica, the Warehouse and its source(s). Merge new standard reports and dashboards into

the new presentation catalog using the Catalog Manager and keep ad-hoc materials from the new

environment.

E. It is sufficient to copy the BI Presentation catalog and BI repository into the new environment.

F. Copy the BI Presentation catalog, create a db dump for the DAC repository and Warehouse and

load these into the new environment. Check connections between DAC, Informatica, the

Warehouse and its source(s).

Answer: D

QUESTION NO: 33

Some users need a new Critical Success Factor or Ratio based on a measure that is not available.

How would you help them in a way that is the least time consuming?

A. Start looking in the source database(s) for base elements. Next step would be to check BTL if

these are already mapped and available in the warehouse. If not, build new ETL, register ETL and

new warehouse objects in DAC and model in BI repository. If available, build the new ratio in the

Business Model and Mapping Layer, set available in the presentation layer and test in Answers.

B. Start looking for base elements in the physical layer in the repository. If available you can

directly build the ratio in the Business Model and Mapping Layer, set available for querying in the

presentation layer and test results in Answers. If not available, check the warehouse tables and

lastly the source tables.

C. Directly start building SDE and SIL mappings to enhance the warehouse with extra columns.

Register the mappings and new warehouse objects in the DAC, run the ETL and model in the BI

repository. Test your work in Answers.

D. Build a request in Answers based on the online BI Repository and create your new ratio as a

new column based on other columns.

E. Build a request in Answers directly on the source data available to you and create the new ratio

as a new column in your report.

Answer: A

QUESTION NO: 34

Considering loading a fact named w_xxx_A, what is the exact sequence in which the mappings

related fact are loaded?

A. SDE -> PLP-> SIL

B. SDE -> SIL -> PLP

C. SIL -> SDE -> PLP

D. PLP-> SIL -> SDE

Answer: B

QUESTION NO: 35

By default for a session in Informica, which properly is used to configure the minimum number of

errors to be encountered, to mark the session as failed?

A. Error limit

B. Minimum Errors

C. Stop on Errors

D. Error Benchmark

Answer: D

QUESTION NO: 36

How many Informatica Repository Servers can be configured with a single DAC server?

A. One

B. Two

C. Three

D. Any number

Answer: A

QUESTION NO: 37

Which combination of the following machines represents an appropriate architecture for an Oracle

BI Applications implementation?

i) Machine A running DAC Server and DAC Client

ii) Machine B running DAC Server and Informatica Services

iii) Machine C running Informatica Services and Informatica Client tools

iv) Machine D running DAC Client and Informatica Client tools

v) Machine E running DAC server and client, Informatica services and Client tools

vi) Machine F running Oracle BI EE components

vii) Machine G running an Oracle Database hosting the data warehouse

viii) Machine H running the source system

A. Machines: A, C, F, G, H

B. Machines: B, D, F, G, H

C. Machines: E, F, H

D. Machines: B, F, G, H

Answer: B

QUESTION NO: 38

In an Oracle BI Cluster Server environment which statement is true?

A. BI Scheduler can reside outside Local Area Network (LAN) whereas the other components

(Clustered BI Servers, Master BI Server, BI Cluster Manager) of Oracle BI Cluster Server must

reside on the same LAN.

B. Clustered BI Servers, Master BI Server, BI Scheduler and Cluster Manager all need to reside in

one Local Area Network (LAN).

C. Cluster Manager can reside outside Local Area Network (LAN) whereas the other components

(Clustered BI Servers, Master BI Server, BI Scheduler) of Oracle BI Cluster Server must reside on

the same LAN.

D. All components of an Oracle BI Cluster Server environment may exist on different Local Area

Networks (LANs), provided the LAN are connected through a single Wide Area Network (WAN).

Answer: A

QUESTION NO: 39

After a year of working with HR and Financial Analytics, your organization chooses to add Sales

Order Management Analytics. How would you combine this new module with the existing ones in

the BI Applications installation?

A. Build a new Sales Order Warehouse and ETL rules to source it. Then import its metadata into

DAC and model as new physical layer in the BI repository. Test your work in Answers.

B. Install Oracle BI Applications Sales Order Management and create the extra objects in the

existing warehouse. Perform a table scan from DAC and check connection pools in the BI

repository. Test your work in Answers and Dashboards.

C. Make a backup of your ETL, the Warehouse, BI Presentation Catalog and BI Repository. Install

Oracle BI Applications Sales Order Management and have the extra objects created by a script in

the existing warehouse and Informatica Repository. Seed the DAC repository with new metadata,

test new Out-of-the-Box execution plans, merge the newly installed BI repository with the backup

and do the same with the presentation catalogs. Enable logging and test your work in Answers

and Dashboards.

D. Make a backup of the BI Presentation Catalog and BI Repository. Run the installation for

Oracle BI Applications Sales Order Management. Merge all new objects with your back-up

materials. Enable logging and test your results in Answers.

E. Build a new Sales Order Warehouse and ETL rules to source it. Then import its metadata into

DAC and build new execution plans based on the new Warehouse objects. Enable the BI

repository with Sales Order metadata and cross-analysis and test your work in Answers.

F. Install Oracle BI Applications Sales Order Management. After the installation check the

connection pools in the BI repository. Test your work in Answers and Dashboards.

Answer: C

QUESTION NO: 40

Which item under DAC connection information will be modified while promoting the code to a new

environment?

A. Execute

B. Setup

C. Subject Area

D. System

Answer: B

QUESTION NO: 41

What is a set of books?

i) It is synonymous with a Ledger

ii) A set of books identifies a company or fund that shares a common chart of accounts structure,

calendar, and functional currency

iii) List of parameters required for the ETL to run successfully

A. i, ii

B. ii, iii

C. i, iii

D. i, ii, iii

Answer: A

QUESTION NO: 42

Which two statements about a micro-ETL are true?

A. They usually handle small subject areas or subsets of larger subject areas.

B. Before a micro-ETL execution plan runs, the DAC Populates refresh date values in the Refresh

Dates child tab of the Execution Plans tab.

C. They are ETL processes that you schedule at very frequent intervals, such as hourly or halfhourly

D. There can be no common subject areas between normal ETL and micro-ETL execution plans.

Answer: A,C

QUESTION NO: 43

Which two Ports are checked while implementing Slowly Changing Dimension in Oracle BI

Application?

A. TYPE1_COLLS_DIFF

B. SYSTEM_COLLS_DIFF

C. TYPE2_COLLS_DIFF

D. CHANGE_COLLS DIFF

Answer: B,D

QUESTION NO: 44

Why do we need to set the NLS Lang Parameter correctly during BI Applications implementation?

A. Astern OBI EE to display the data correctly, based on the language supported by the operating

system.

B. It helps DAC to send commands to Informatica correctly, based on the language supported by

the operating system.

C. It helps the ETL too, Informica, to transform data based on the language supported by the

operating system.

D. It helps EBS to display the data correctly, based on the language supported by the operating

system.

Answer: A

QUESTION NO: 45

What is the name of the Informatica repository that comes as part of the BI Applications

installation?

A. Oracle_BI_DW_Base.rep

B. OracleBIAnalyticsApps.rpd

C. Oracle_BI_DW_Base.rpd

D. OracleBIAnalyticsApps.rep

Answer: A

QUESTION NO: 46

Which Informatica Power Center component is used for configuration of domain, server grid and

services?

A. Repository Manager

B. Designer

C. Workflow Manager

D. Administration Console

Answer: D

QUESTION NO: 47

How does Informatica know which source OLTP and target Datawarehouse connection

information is to be used for task execution in BI Applications?

A. This information is given in the DAC Parameter file.

B. This information is given in Relational connections of Workflow manager.

C. This information is given in two flat files, fiie_source.csv and fiie_target.csv.

D. Informatica doesn't require knowing this information. However, it is required to give this

information in DAC.

Answer: A

QUESTION NO: 48

Which statement is true?

A. SIL stands for Source Independent Load and is used to move the data from staging tables to

Data Warehouse.

B. SIL stands for Source Independent Load and is used to move the data from source to staging

tables of Data Warehouse.

C. SIL stands for Source Intensive Load and is used to move the data from staging tables to Data

Warehouse.

D. SIL stands for Source Intensive Load and is used to move the data from source to staging

tables of Data Warehouse.

Answer: A

QUESTION NO: 49

Data Warehouse Administration Console Is used for which three purposes?

A. Defining ETL subject areas and execution plans

B. Prioritizing and load balancing of the ETL workflow execution

C. Performing automatic index management

D. Managing access rights to the data warehouse

E. Defining custom dashboards queries

Answer: A,B,C



QUESTION NO: 50

How can you be sure that all ETL tasks are executed in the right ordering by Informatica?

A. You can be sure after a successful batch run of the ETL in Informatica Powercenter.

B. You can never be really sure.

C. Execute all ETL using DAC Subject Areas embedded in execution plans. DAC will calculate the

ordered tasks.

D. Execute single ETL mappings in parallel in Informatica Powercenter Workflow Manager.

E. Answers A or D.

Answer: C

QUESTION NO: 51

How does the DAC task instruct Informatica whether to run a full load or incremental load?

A. DAC issues additional parameters to Informatica.

B. DAC does not handle such responsibilities.

C. Informatica intelligently decides whether to run a full load or not.

D. DAC issues separate commands for full load and incremental load.

Answer: A

QUESTION NO: 52

Upon which two entities can security be based when using PeopleSoft as source application?

Analytics Warehouse in case of A.

Sales order information of a Stock Broker or B. HR information of a small city?

A. Capacity planning for A and B is the same and focused on non-frequent large ETL runs.

B. Capacity planning for A is focused on frequent, smaller ETL runs, including micro batches and

iBot schedules and active cache management using scheduled cache purging and polling tables.

For B, capacity planning is focused on less frequent bigger ETL runs and cache management

using scheduled cache purging.

C. Capacity planning for A is focused on less frequent, bigger ETL runs and cache management

using scheduled cache purging. Capacity planning for B is focused on frequent, smaller ETL runs,

including micro batches and iBot schedules and active cache management using scheduled cache

purging and polling tables.

D. Capacity planning for A and B is the same and focused on infrequent, small ETL runs.

E. Capacity planning for A and B is the same and focused on very frequent, small ETL runs

F. Capacity planning for A and B is the same and focused on very frequent, large ETL runs.

Answer: B

QUESTION NO: 54

Which two parameters are to be set while configuring BI Applications for Supply Chain Analytics?

A. Inventory Master Id

B. Category Master Id

C. Category Set ID

D. Inventory Category Set Id

Answer: A,B

QUESTION NO: 55

A shipping company uses many standard forms that need to contain Customer name, address,

contract information and a perfectly printable barcode for tracking orders. What functionality would

you advise this organization to use from Oracle BI Applications?

A. Reuse as many Out-of-the-Box reports as possible.

B. Build requests, include these on dashboard pages and include PDF files to show the barcodes.

C. Schedule requests using Delivers, print these in PDF and then deliver to email addresses.

D. Build reports in BI Publisher based on existing BI requests or BI Presentation Layer columns.

E. Build reports using the Microsoft Office plug-in based on BI Presentation Layer columns.

F. Answer D and E are both valid possibilities.

Answer: F

QUESTION NO: 56

After you configured object and data security the user group representatives also express their

wish to change the workflow order in the Presentation Catalog available to them. How would you

do that?

A. Add new reports or reuse existing reports in Answers and modify the column navigation

behavior to define the workflow. Add the first report in the flow on a high-level dashboard page.

B. Add or modify guided navigation on a Dashboard page. The link should navigate to a report in

the workflow.

C. Add or modify links on a Dashboard page. The link should navigate to a report in the workflow.

D. Answer A and B combined

E. Answer A and C combined

F. Answer A and E are both possibilities.

Answer: B

QUESTION NO: 57

Your organization’s management expresses the need for having specific Web content available for

specific user groups, including rules that ensure data security. How would you make this work?

A. Run specified execution plans in DAC and enable data security in user groups in the BI

repository.

B. Run specified execution plans in DAC, create session variable and enable data security on user

groups in the BI repository.

C. Create session variable to define the user group, and then enable data and objects security in

the BI repository.

D. Create specific dashboards including specific content and enable object security for the user

groups in the Catalog Manager or Administration link in the web interface.

E. Answer A and D combined.

F. Answer A and D combined.

Answer: D

QUESTION NO: 58

Which utility is used by the DAC server to issue commands to read information in the Informatica

repository?

A. Ddlimp

B. cryptotools

C. pmrep

D. pmcmd

Answer: D

QUESTION NO: 59

Which three attributes identify a single set of books?

A. Chart of accounts

B. Currency

C. Calendar definition

D. Company name or identifier

Answer: A,B,C

 QUESTION NO: 60

Which statement is true about the safe path in SDE and SIL mappings when implementing a Type

I customization?

A. The safe path is used by all lookup data and is used to populate variables.

B. The safe path columns in a mapping should not be duplicated or renamed.

C. The safe path defines a path through which all extension logic should be routed and is indicated

in the mapping by a placeholder column named x_custom.

D. The safe path defines a path through which all extension logic should be routed and is indicated

in the mapping by a placeholder column named x safePath.

Answer: C

QUESTION NO: 61

What is the significance of the Informatica parameter files: parameterfileOLTP and

parameterfileDW?

A. They help in configuring the domain values and other source files

B. They are generated at run time to provide Informatica, the parameters required for ETL

C. They hold the predefined task-level parameters defined

D. They contain the standard parameters for each task that is to be configured in DAC

Answer: D

QUESTION NO: 62

In Dashboards, the data security is implemented by_____.

A. Oracle BI EE using the concept of "WEBGROUPS" session variable

B. Oracle BI EE using the concept of "GROUP" session variable

C. Oracle Data warehouse, using standard relational database features

D. Object security is not implemented in Oracle BI Applications

Answer: B

QUESTION NO: 63

By default how many aging buckets are configured for Accounts Payable/Receivables Aging

reports?

A. One

B. Two

C. Three

D. Four

Answer: D

QUESTION NO: 64

Which two are considered Informatica Type II Customizations?

A. Addition of new Fact and Dimension tables to the data warehouse for packaged application

datasource(s).

B. Addition of new Fact and Dimension tables to the data warehouse for non-packaged application

datasource(s).

C. Addition of new rows (to existing tables) from the source systems for non-packaged application

datasource(s).

D. Addition of new rows (to existing tables) from the source systems for packaged application

datasource(s).

Answer: A,C

QUESTION NO: 65

Which types of data level security are available in BI Applications?

A. i, iii, v, vi

B. i, ii, iii, iv

C. i, ii, iii, v, vi

D. i, ii, iii, iv, v, vi

Answer: B

QUESTION NO: 66

The parameter files generated by DAC are_____.

A. created for each workflow, using the combination of parameters specified in the

parameterfileDW.txt, parameterfileOLTP.txt, and DAC parameters

B. created for each mapping, using the combination of parameters specified in the

parameterfileDW.txt, parameterfileOLTP.txt, and DAC parameters

C. created for each mapping, using the combination of parameters specified in the

parameterfileDW.txt and parameterfileOLTP.txt

D. created for each workflow, using the combination of parameters specified in the

parameterfileDW.txt and parameterfileOLTP.txt

Answer: D

QUESTION NO: 67

The Out of the Box BI Applications reports that are included on the dashboards are role based.

How do you support these roles specifically in workflows?

A. Roles can be supported in workflows by using session variables as filter in permission settings

such as enabling access permissions for user groups and data security, defining workflows by

guided navigation and column behavior, dashboard links and conditional guided navigation on

dashboard sections.

B. Roles can be supported in workflows only by enabling session variables in connection pools.

C. Roles can be supported in workflows entirely by defining dimensional hierarchies and using the

default drill functionality.

D. Roles can be supported in workflows only by conditional formatting and using the STYLE

session variable.

E. Roles can be supported in workflows by user groups, data security, and conditional formatting.

Answer: A

QUESTION NO: 68

Your organization plans to deploy BI Applications for the first time. In order to make sure that the

approximately 300 users are enabled to work in a smooth and performing way what would you

consider?

A. Use at least one environment for development and testing and one for production. In each

environment install the Oracle BI Server, DAC and Informatica PowerCenter on the same

machine. Install the Oracle BI Presentation server on a second machine. Only enable caching in

the development environment. Enable automatic purging and seeding of the cache. Enable object

security.

B. Use one environment and install the Oracle BI Server, DAC and Informatica on the same

machine and install the Oracle BI Presentation server on a different machine. Enable automatic

purging and seeding of the cache.

C. Use at least one environment for development and testing and one for production. In each

environment install the Oracle BI Server, DAC and Informatica PowerCenter on the same

machine. Install the Oracle BI Presentation server on a second machine. Keep the data

warehouse separated from the OLTP database. Only enable caching in the production

environment. Enable automatic purging and seeding of the cache. Enable object and data

security.

D. Use at least one environment for development and testing and one for production. Enable

object and data security per user, enable logging and disable caching.

E. Use at least one environment for development and testing and one for production. Install DAC

and Presentation server on one machine and install Informatica PowerCenter and Oracle BI

Server on one machine. Install the data warehouse in the OLTP database on a third machine.

F. Use at least one environment for development and testing and one for production. Install DAC

and Presentation server on one machine and install Informatica PowerCenter and Oracle BI

Server on one machine. Install the data warehouse in the OLTP database on the Oracle BI Server

machine.

Answer: C

QUESTION NO: 69

In which BI Applications release can the calendar definition be extracted from the source

applications?

A. Release 7.9.6

B. Release 7.9.5.1

C. All releases of BI Applications

D. It is not possible in any released version of BI Applications

Answer: A

QUESTION NO: 70

Which module is not covered in BI Applications for EBS?

A. Financial Analytics

B. HR Analytics

C. Procurement and Spend Analytics

D. Marketing Analytics

Answer: D

QUESTION NO: 71

What are action links used for?

A. Direct navigation from source application to BI reports

B. Direct navigation from BI record to transactional data source

C. Functionality to invoke iBots

D. Drilling down to transactional-level data within the report

Answer: B

Till Next Time