.............. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
1. Data Mining
2.Data Warehousing
3.Document Mining
4.Text Mining
Posted Date:-2022-03-02 21:53:16
A lookup transformation is used to look up data in
1.flat file
2.Relational table (wrong)
3.view
4.All of the above
Posted Date:-2022-03-02 21:35:05
An ......... system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
1.OLAP
2.OLTP
3.Both of the above
4. None of the above
Posted Date:-2022-03-02 21:54:08
Bins created in function are similar to:
1.Case Statement of Expression Function
2. Cast Statement of Conversion Function
3.Count Statement of Aggregate Function
4.RCount of Running Aggregate Function
Posted Date:-2022-03-02 21:52:45
Can DAC send an email just in case of any failures?
1.Yes
2.no
3.all of the above
4.None of the mentioned
Posted Date:-2022-03-02 21:48:13
Can we generate alpha-numeric value in sequence generator?
1. yes
2.no
3.all of the above
4.None of the mentioned
Posted Date:-2022-03-02 21:36:49
Can we run multiple execution plan at the same time in DAC?
1.Yes.
2.no
3.all of the above
4.None of the mentioned
Posted Date:-2022-03-02 21:47:33
Dimension tables are denormalized in nature ? True or False.
1.true
2.False
3.all of the above
4.None of the mentioned
Posted Date:-2022-03-02 21:42:47
For moving your shared dashboard and reports from dev to QA or Production you should:
1.paste dev catalog to qa / prod environment
2. paste only updated atr files to qa/prod
3.merge catalog changes through catalog manager
4.paste files and associated atr files to qa/prod
Posted Date:-2022-03-02 21:24:41
How can we load time dimension?
1.through Sql transformation
2.through Dimensional Loader (wrong)
3.Through Lookup
4.Through Store Procedure
Posted Date:-2022-03-02 21:43:11
How can you show updated changes made to online rpd, without restarting BI Services?
1.Restart Java Host Services (Weblogic / oc4j)
2.Reload EPT
3.Reload Server Metadata
4.Refresh Display
Posted Date:-2022-03-02 21:51:54
If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?
1. yes
2.no
3.all of the above
4.None of the mentioned
Posted Date:-2022-03-02 21:47:19
If you want to limit / restrict data based on some dimension attribute, you should:
1.Use Filter option
2.Use Function Option
3.Use Column Format Option
4.Use Sorting Option
Posted Date:-2022-03-02 21:52:21
In ODI, references can be represented by
1.Simple equalities between columns in tables
2.Complex relationships between columns in tables
3.Expressions that must evaluate to true or false
4.All of the above
Posted Date:-2022-03-02 21:55:01
Repository can be uploaded/ updated from?
1.Capacity Management Tab of Fusion MiddleWare
2.Diagnostics Tab of Fusion MiddleWare
3.Overview Tab of Fusion MiddleWare
4.Deployment Tab of Fusion MiddleWare
Posted Date:-2022-03-02 21:25:53
The data is stored, retrieved and updated in........
1.OLAP
2.OLTP
3.SMTP
4.FTP
Posted Date:-2022-03-02 21:53:39
We can set Bridge table from
1.Properties of Physical Tables
2.Properties of Logical Table
3.Properties of LTS
4.Properties of Presentation Table
Posted Date:-2022-03-02 21:24:19
What are the components of DAC
1. DAC Server
2.DAC Client
3.W ebLogic Server
4.Informatica Server
Posted Date:-2022-03-02 21:47:57
What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?
1.Add one dummy port in two sources.
2.Use Joiner transformation to join the sources using dummy port
3.Use Union
4.In expression trans assign '1' to each port
Posted Date:-2022-03-02 21:40:53
What are the types of groups in Router transformation?
1.User defined group
2.Multiple Group
3.Default Group
4.Single Group
Posted Date:-2022-03-02 21:42:28
What cannot be done in presentation layer of Repository?
1.Nesting of folders
2.Set implicit fact column
3.Permission grant to groups/users for security
4. Performing calculations of measures
Posted Date:-2022-03-02 21:23:56
What do you use to Model a schema where the dimension table and the fact table have a many to many relationship ?
1.Complex Join
2.Aggregate Table
3.Helper Table
4.Bridge Table
Posted Date:-2022-03-02 21:49:33
What is a mapplet?
1.Combination of reusable transformation.
2.Combination of reusable mapping
3.Set of transformations and it allows us to reuse
4.None of these
Posted Date:-2022-03-02 21:44:23
What is default join of joiner?
1. Full Outer
2. Detail Outer
3.Normal
4.Master Outer
Posted Date:-2022-03-02 21:41:40
What is meaning of tracing level?
1.Data store in cache (wrong)
2.Data store in database
3.Data store in log file
4. Data store in buffer
Posted Date:-2022-03-02 21:37:40
What is the default join of Source Qualifier?
1.Left Outer join
2.Equi Join
3.Inner-equi join
4.Outer join
Posted Date:-2022-03-02 21:42:07
What is the default source option for update strategy?
1.Update or Delete
2.Update or Insert
3. Insert or Update
4. Date Driven
Posted Date:-2022-03-02 21:41:18
What is the name of the object that is used to initialize dynamic repository variable and system session variables for OBIEE Sessions ?
1.Tokens
2. Variables
3.Initialization Blocks
4. Meta Tags
Posted Date:-2022-03-02 21:50:29
What kind of DAC Repository Objects Held in Source System Containers?
1.Indexes
2.Tasks
3.Schemas
4.Workflows
Posted Date:-2022-03-02 21:48:36
What will happen if informatica server doesn't find session parameter and variable?
1.Work flow will fail
2.Automatically it will created
3.Give a message to user to put it
4.None of these
Posted Date:-2022-03-02 21:45:57
When you open a sales.rpd file in the BI Server repository directory, it displays a message “The repository sales.rpd can only be opened as Read-Only. Do you want to open it ?”. What is the correct statement ?
1.Oracle BI Presentation services is running
2.Sales.rpd file can be opened only in the Online mode
3. Oracle BI Server is running and Sales.rpd is the default repository
4.none of the above
Posted Date:-2022-03-02 21:49:09
Which are the load types in Informatica session?
1.Bulk
2.Terse
3.Normal
4. All of these
Posted Date:-2022-03-02 21:43:31
Which dimension is collection of random transactional codes, flags and/or text attributes?
1.degenerated
2. scd
3. junk
4. confirmed
Posted Date:-2022-03-02 21:39:32
Which is both connected and unconnected?
1.External Store Procedure
2.Store Procedure
3.Lookup
4.Advanced External Procedure Transformation
Posted Date:-2022-03-02 21:36:26
Which is not valid type of set operation for combine with similar request?
1.Union
2.Intersect
3.Minus
4.SubSet
Posted Date:-2022-03-02 21:51:07
Which layer within the Oracle BI Repository provides customized, role based views to users who build analyses and other client applications ?
1.Physical Layer
2.ETL Layer
3. Business Model and Mapping Layer
4.Presentation Layer
Posted Date:-2022-03-02 21:49:58
Which load type we should use in case of less amount of data and recover session?
1.verbose
2. normal
3.bulk
4.All of these
Posted Date:-2022-03-02 21:43:52
Which of the following is not a kind of data warehouse application?
1.Information processing
2.Analytical processing
3.Data mining
4.Transaction processing
Posted Date:-2022-03-02 21:54:33
Which of them is/are not Time Series Function?
1.Ago()
2. Todate()
3.Period()
4.PeriodRolling()
Posted Date:-2022-03-02 21:23:35
Which of these is not Hierarchy type?
1.Skipped Hierarchy
2. Composite Hierarchy
3.Parent Child Hierarchy
4.Ragged Hierarchy
Posted Date:-2022-03-02 21:25:24
Which one contains input and output transformations?
1. maplet
2.reusable transformation
3. reusable mapping
4.None of the mentioned
Posted Date:-2022-03-02 21:38:42
Which one is not a designer tool creating transformations?
1.Transformation developer
2.Mapping designer
3. Mapplet designer.
4.target designer
Posted Date:-2022-03-02 21:40:25
Which one is not a target Option for file on the Servers?
1.FTP
2.Loader
3.MQ
4.ERP
Posted Date:-2022-03-02 21:40:02
Which one is not an option in update strategy?
1. dd_reject
2.4
3.2
4.dd_delete
Posted Date:-2022-03-02 21:45:05
Which one support heterogeneous join?
1.source qualifier
2.joiner
3. look up
4.None of the mentioned
Posted Date:-2022-03-02 21:35:23
Which output file is not created during session running?
1.Session log
2.workflow log
3.Error log
4.cache files
Posted Date:-2022-03-02 21:35:45
Which transformation acts like CASE.. WHEN in Sql?
1.filter
2.router
3.aggregator
4.look up
Posted Date:-2022-03-02 21:45:30
You can apply restriction/ filtration to data in metadata repository in:
1.Physical Layer Alias Table
2.Logical Table
3. Logical Table Source
4.Presentation Table
Posted Date:-2022-03-02 21:25:04
You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?
1.Manage Sessions
2.Manage Interactive Dashboard
3.Manage Privilege
4.Manage Presentation catalog group or users
Posted Date:-2022-03-02 21:50:48
You can start all BI services from fusion middleware from:
1.Capacity Management Tab of Fusion MiddleWare
2. Diagnostics Tab of Fusion MiddleWare
3.Overview Tab of Fusion MiddleWare
4.Deployment Tab of Fusion MiddleWare
Posted Date:-2022-03-02 21:26:29