Interview Questions.

Question 1. What Is A Bridge Table ?

Answer :

If you want to attach two tables where there is no courting you could use a 3rd bridge table for connecting them on the way to have not unusual columns in each tables, this is utilized in BMM Layer.

Question 2. What Are The Key Configuration Files In Obiee?

Answer :

NQSConfig.Ini, NQSCluster.Ini, odbc.Ini, instanceconfig.Xml

Siebel - CRM Interview Questions
Question three. How Time Based Triggered Report Can Be Generated?

Answer :

Using Scheduler - ibots

Question 4. What Is Ibot?

Answer :

Ibot is an scheduling agent, used to time table reviews to be sent throughout diverse gadgets including e mail, pager, cellular, other devices and many others.

Siebel - CRM Tutorial
Question five. What R Diff Types Of Joins That Are Possible In Obiee Rpd?

Answer :

Complex Join – to apply more than one situations, such A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID like that Natural Join / Equi Join

Informatica Interview Questions
Question 6. Difference Between A Session And Repo Variable?

Answer :

Session variables are much like dynamic repository variables in that they acquire their values from initialization blocks. Unlike dynamic repository variables, however, the initialization of consultation variables isn't scheduled. When a consumer starts a session, the Oracle BI Server creates new times of consultation variables and initializes them.

A repository variable has a single cost at any point in time. Repository variables may be used as opposed to literals or constants in Expression Builder inside the Administration Tool. The Oracle BI Server substitutes the cost of the repository variable for the variable itself inside the metadata.

Unlike a repository variable, there are as many instances of a consultation variable as there are active periods at the Oracle BI Server. Each instance of a session variable may be initialized to a one of a kind cost.

(or)

Session variables can have exclusive values for each user, repository variables have the same price for anybody.

There are  types of consultation variables:

System session variables: out of the field variables like USER
Non-system session variables: user-described variables, can have extraordinary values for each user and are generally used to customize user experience , for example you can have a SALES_REGION variable to show only statistics applicable to the person's place.
Repository variables also have 2 subtypes:

Static repository variable: Fixed value which could most effective be modified with the admin device, can be used to update hardcoded values like database schemas and person names in connection swimming pools.
Dynamic repository variable: These preserve values that practice to any user, as an example currency exchange costs.
Both System variables and dynamic repository variables get their values from initialization blocks which can contain SQL.

Question 7. How Can I Have Two Different Columns From Two Different Tables Or Subject Areas?

Answer :

Using conformed dimensions, you can fetch multiple metrics throughout various records, however the be a part of need to be of the identical grain / equal level of statistics detail.

Informatica Tutorial IBM Cognos Interview Questions
Question 8. How Can U Use Saved Filters And Where Will You Save The Filters?

Answer :

Shared Folders/XYZ Folder/ It carries two folders:

Prompts – saved filters can be stored right here.
Reports
Question 9. Have You Worked In Dashboard.. When U Run A Dashboard... How Will U Stop The Dashboard Report Run Automatically?

Answer :

By clicking at the cancel button, you may stop a selected report positioned on the dashboard

OBIEE Interview Questions
Question 10. What Is A Surrogate Key?

Answer :

A surrogate secret is an artificially generated key, commonly more than a few. A surrogate key, within the stage mixture table, simplifies this be a part of and removes useless columns (stage number one key) from the truth desk, resulting in a smaller-sized reality desk. Adding surrogate keys to the measurement (level) aggregate tables can simplify joins to the reality tables and might improve question overall performance. Additionally, a surrogate key makes sure that every combination table has a completely unique identifier.

IBM Cognos Tutorial
Question eleven. What Is A Request Variable And In A Table How Can I Get The Distinct Record From The Table... And If I Say 'wonderful All'.. What Data Will U Get?

Answer :

So precisely what's a request variable?  Well, placed succinctly:

   A request variable is a variable this is used to briefly override the fee of a consultation variable.

And, with a touch greater precision, a request variable is:

   A variable this is described within the Presentation Services;

   A variable whose scope (web page or dashboard) is that of the associated dashboard activate that defines the request variable and its value;

   A variable whose call need to now not in shape that of a repository variable or a protection system session variable; and

   A variable that overrides the fee of the corresponding session variable (have to it exist) for the reason of BI Server request parsing and physical SQL construction for all requests which can be issued from dashboard pages that fall within the scope of the variable’s definition.

Note, using a request variable does now not alternate the actual fee of a session variable – neither temporarily nor completely.  It without a doubt seems to trade the value for certain functions throughout the execution of a request.

Siebel System Admin Interview Questions
Question 12. What Is Explain Plan?

Answer :

From the BI aspect, you can essentially use 2 types of suggestions.

The Index hint instructs the optimizer to test a particular index rather than a table.

The Leading trace forces the optimizer to build the be part of order of a question with a targeted table.

Importantly, the Explain Plan includes the subsequent information concerning your question.

Ordering of the tables referenced
Access technique for every desk
Join method for every be part of operation
Data operations, consisting of clear out, type or aggregation
And further:

Optimization (Cost and Cardinality)
Partitioning
Parallel Execution
Siebel - CRM Interview Questions
Question thirteen. What Are Aggregations And If We Have To Do It On Physical Layer Side Then How U Do It?

Answer :

You can use the Aggregate Persistence Wizard to create the SQL file with a view to be used to create mixture tables and map them into the metadata.
Do now not use aggregate staying power in opposition to tables with active Virtual Private Database (VPD) safety filters. There is a possibility that the aggregate statistics is probably endured without the VPD filter out, posing a security risk.
The Aggregate Persistence Wizard is a nifty software for growing, modelling and populating mixture tables available in OBIEE 10g and 11g. This utility is specifically useful to quick build a unmarried aggregation layer upon federated heterogeneous bodily resources.  OBIEE will create, version and populate aggregate dimensions and information based upon the intelligence you have got built into the RPD. This avoids re-writing the identical good judgment into your ETL.
OBIEE Tutorial
Question 14. What Kind Of Sources Can Be Connected To Obiee ?

Answer :

OBIee may be plugged on Relational Databases, Cubes or Flat files, with the subsequent constraints :

The sources need to be modeled as megastar schemas or snowflakes schemas with the intention to have  an green and secure conduct.
In case of more than one sources at once in OBIee used collectively, be aware that OBIee will behavior the wanted joins itself, and OBIee isn't always a database.
Question 15. Is It Possible To Create A Report Based On Two Subject Areas (instance : Sales And Supply Chain) ?

Answer :

Theoretically, yes. In exercise, the two subject place need to come from the same enterprise model in the repository, that's pretty vain. Then, we can bear in mind the two following alternatives :

Create an evaluation with “combine request”: one subrequest by means of problem area. Note that it’s elaborate to enforce for widespread customers.
Set up a transverse subject area, with the intention to gather tables from both commercial enterprise topics.
PL/SQL and Informatica Interview Questions
Question 16. How To Get Real Physical Sql Sent By Obiee To The Database?

Answer :

First of all, test the price of your consultation variable LOGLEVEL.
5 is first-rate.
Then, move into Administration -> Manage sessions.
Find your question (at the lowest of the list), and click on on “View log”.
If you hit the cache, you'll see “cache hit on query”. Otherwise, you will see the physical SQL beneath the logical SQL.
Question 17. How To Configure An Obiee Environment ?

Answer :

In OBIee 11g, predominant configuration gadgets are controlled in Enterprise Manager (internet interface).
However, some configurations are nonetheless located in configuration documents, like NQSConfig.Ini, NQSCluster.Ini, odbc.Ini, and instanceconfig.Xml.
Siebel EAI Interview Questions
Question 18. In A Troubleshooting Perspective, How Can I See Log Files ?

Answer :

Old approach in 10g model consisted in opening log documents on the server.
Now, in 11g, log facts is consultable in Enterprise Manager.
Informatica Interview Questions
Question 19. What Is Query Repository Tool?

Answer :

It is software of Siebel/OBIEE Admin device.
Allows you to examine the repository metadata tool.
For example: look for gadgets based totally on name, type.

Examine relationship between metadata gadgets like which column in the presentation layer maps to which desk in physical layer.

Question 20. What Is Jdk And Why Do We Need It?

Answer :

Java Development Kit (JDK), A software program bundle that includes the minimum set of tools needed to write, collect, debug, and run Java applets.
Oracle doesn’t propose Opaque Views because of performance concerns, so why/whilst do we use them?
An opaque view is a bodily layer table that consists of pick announcement. An opaque view have to be used simplest if there is no other answer.
Oracle Data Integrator (ODI) Interview Questions
Question 21. Can You Migrate The Presentation Layer To A Different Server?

Answer :

No we must migrate the whole web & RPD documents

Question 22. How Do You Identify What Are The Dimension Tables And How Do You Decide Them During The Business/records Modeling?

Answer :

Dimension tables comprise descriptions that information analysts use as they query the database. For instance, the Store desk incorporates shop names and addresses; the Product desk includes product packaging data; and the Period table contains month, zone, and 12 months values. Every table includes a primary key that includes one or greater columns; every row in a desk is uniquely identified by way of its primary-key fee or values.

Question 23. Why Do We Have Multiple Lts In Bmm Layer? What Is The Purpose?

Answer :

To improve the performance and query reaction time.

IBM Cognos TM1 Interview Questions
Question 24. What Is The Full Form Of Rpd?

Answer :

There is no full shape for RPD as such, it's far only a repository document (Rapidfile Database).

IBM Cognos Interview Questions
Question 25. How Do I Disable Cache For Only 2 Particular Tables?

Answer :

In the bodily layer, right click on at the desk there we will have the option which says cacheable.

Question 26. How Do You Split A Table In The Rpd Given The Condition?

Answer :

(The situation given changed into Broker and patron in the identical desk) Split Broker and patron.

We need to make an alias desk within the physical layer.

Oracle BPM Interview Questions
Question 27. What Type Of Protocol Did You Use In Sas?

Answer :

TCP/IP

OBIEE Interview Questions
Question 28. What Is Logging Level? Where Can You Set Logging Levels?

Answer :

You can permit logging degree for character users; you cannot configure a logging level for a set.Set the logging stage primarily based on the quantity of logging you need to do. In everyday operations, logging is usually disabled (the logging degree is ready to zero). If you make a decision to enable logging, choose a logging stage of 1 or 2. These  ranges are designed to be used by using Siebel Analytics Server administrators.

Set Logging Level:

In the Administration Tool, pick out Manage > Security.
The Security Manager conversation field appears.
Double-click on the consumer’s person ID.
The User dialog container seems.
Set the logging degree through clicking the Up or Down arrows subsequent to the Logging Level subject.
Question 29. What Is Variable In Obiee?

Answer :

You can use variables in a repository to streamline administrative obligations and regulate metadata content material dynamically to alter to a converting statistics surroundings. The Administration Tool consists of a Variable Manager for defining variables.

Cognos ReportNet (CRN) Interview Questions
Question 30. What Is System Variable And Non-system Variable?

Answer :

System variables: System variables are consultation variables that the Siebel Analytics Server and Siebel Analytics Web use for particular purposes. System variables have reserved names, which can not be used for other kinds of variables (along with static or dynamic repository variables, or for non-device consultation variables). When the usage of these variables inside the Web, preface their names with NQ_SESSION. For instance, to filter a column on the value of the variable LOGLEVEL set the filter out to the Variable NQ_SESSION.LOGLEVEL.

Non-device variables: A not unusual use for non-system consultation variables is putting user filters. For example, you can define a non-device variable referred to as SalesRegion that might be initialized to the call of the person’s income location. You may want to then set a protection filter out for all contributors of a collection that would permit them to peer best data pertinent to their area.

When using these variables within the Web, preface their names with NQ_SESSION. For instance, to filter out a column at the cost of the variable SalesRegion set the filter to the Variable NQ_SESSION.SalesRegion.

Question 31. What Are Different Types Of Variables? Explain Each.

Answer :

There are two instructions of variables:

Repository variables
Session variables
Repository variables: 

A repository variable has a single cost at any point in time. There are two styles of repository variables:

Static: This value persists, and does now not change till a Siebel Analytics Server administrator decides to alternate it.

Dynamic: The values are refreshed by way of information lower back from queries. When defining a dynamic repository variable, you will create an initialization block or use a preexisting one that contains a SQL question. You can even installation a agenda that the Siebel Analytics Server will observe to execute the query and periodically refresh the price of the variable.

Session Variables:

Session variables are created and assigned a price while each consumer logs on.

There are  varieties of consultation variables:

system
non-machine.
Question 32. What Is The Cache Management? Name All Of Them And Their Uses. For Event Polling Table Do You Need The Table In Your Physical Layer?

Answer :

Monitoring and handling the cashe is cache control.There are 3 approaches to do that.

Disable caching for the system.(NSQconfig INI record), Cache persistence time for detailed physical tables and Setting occasion polling desk.

Disable caching for the machine.(INI NQ config document :

You can disable caching for the whole system via putting the ENABLE parameter to NO within the NQSConfig.INI file and restarting the Siebel Analytics Server. Disabling caching stops all new cache entries and prevents any new queries from using the prevailing cache. Disabling caching permits you to permit it at a later time without dropping any entries already saved inside the cache.

Cache staying power time for detailed bodily tables:

You can specify a cacheable attribute for every bodily table; that is, if queries related to the specified desk may be added to the cache to answer future queries. To enable caching for a specific bodily desk, pick out the desk in the Physical layer of the Administration Tool and pick out the option Make desk cacheable inside the General tab of the Physical Table residences dialog box. You can also use the Cache Persistence Time settings to specify how long the entries for this table ought to persist within the question cache. This is beneficial for OLTP facts assets and other records assets which can be updated frequently, probably right down to each few seconds.

Setting event polling table:

Siebel Analytics Server event polling tables save facts about updates within the underlying databases. An application (which include an utility that loads records right into a facts mart) may be configured to add rows to an occasion polling table on every occasion a database table is updated. The Analytics server polls this table at set intervals and invalidates any cache entries similar to the updated tables.

For event polling table ,It is a standalone table and doesn’t require to be joined with different tables inside the physical layer.

Oracle BI Publisher Interview Questions
Question 33. What Is Authentication? How Many Types Of Authentication.

Answer :

Authentication is the system, via which a gadget verifies, thru the use of a person ID and password, that a person has the important permissions and authorizations to log in and get right of entry to facts. The Siebel Analytics Server authenticates each connection request it receives.

Operating gadget authentication
External table authentication
Database authentication
LDAP authentication
Siebel System Admin Interview Questions
Question 34. What Is Object Level Security?

Answer :

There are two kinds of item degree protection:

Report Level
Web Level
Repository stage: In presentation layer we can set Repository degree protection with the aid of giving permission or deny permission to users/businesses to see precise desk or column.

Web level: this provides security for gadgets saved within the OBIEE net catalog, including dashboards, dashboards pages, folder, and reports you may best view the gadgets for that you are legal. For example, a mid-degree manager may not be granted get admission to to a dashboard containing summary facts for an entire department.

Question 35. What Is Data Level Security?

Answer :

This controls the sort an amount of statistics that you could see in a report. When multiple customers run the equal report the effects which might be lower back to each rely upon their get admission to rights and roles inside the employer. For example a income vice chairman sees effects for all areas, at the same time as a sales consultant for a specific vicinity sees handiest records for that vicinity.

Question 36. What Is The Difference Between Data Level Security And Object Level Security?

Answer :

Data level safety controls the sort and amount of information that you may see in reports. Object level safety provides safety for objects saved inside the OBIEE net catalog, like dashboards, dashboards pages, folder, and reports.

PL/SQL and Informatica Interview Questions
Question 37. How Is Security Set Up In Obiee? How Many Methods Of Security Can Be Set Up In Obiee…?

Answer :

Authentication is system of confirming whether the person is a legitimate consumer or now not. Is he a part of this organisation. Is he an worker of our outside suppliers.

Authorization is procedure of giving get admission to to one-of-a-kind pieces of the OBIEE. One user “UserA” can get right of entry to dashboards, can create iBots, can agenda reports and can do administrative tasks. Another consumer “UserB” can see handiest part of what “UserA” has access to and “UserB” has get right of entry to to some other tabs of the dashboard that “UserA” does not.

This layer of isolating who can access what is finished as part of Authorization.

Question 38. How Does Obiee Handle Authentication?

Answer :

It’s very bendy and may be incorporated to certainly one of your existing technologies like LDAP, Oracle EBS, AD, and Oracle Database. So, do the equal username should exist in OBIEE safety layer as a part of RPD improvement? Yes, by using default, OBIEE stores listing of usernames and passwords and tests incoming credentials in opposition to it.

Question 39. Heard About External Table Authentication? Where Does This Come Into Play?

Answer :

Instead of storing usernames and passwords directly within the RPD, those are stored in the database for higher control purposes. This also facilitates in RPD migration and deployment across more than one environments.

Question 40. How Is Authorization Handled In Obiee?

Answer :

Authorization is completed as a part of security in Presentation Services.

Siebel EAI Interview Questions
Question 41. Does Obiee Have Two Layers Of Security?

Answer :

Yes, first on the RPD degree and 2d at the presentation services level.

Question 42. What Kind Of Privileges Can Be Granted From Presentation Services Level?

Answer :

Access to iBots, certain tabs inside the dashboard, delivers, indicators, time table reports and many others and many others..

Oracle Data Integrator (ODI) Interview Questions
Question 43. Why Obiee Security Is Different Compared To Other Bi Tools?

Answer :

Because it’s very bendy and might integrate into any current protection structure an agency has constructed and decreases the want for one more layer of administration..
Did Oracle OBIEE do a great task of speaking and convincing the consumer network concerning the security architecture.
Probably not… I apprehend the complexity in the back of this and the mere flexibility of the device makes this even difficult.
Question 44. What Is The Default Location Of A Repository File?

Answer :

[InstalledDirectory]OracleBIserverRepository.

Question forty five. What’s Xmla And Where Is It Used For In Obiee Context?

Answer :

The Provider Services device that includes Essbase is used to offer the interface, with Oracle BI Server speakme to Essbase thru its XMLA interface. (Need to find the solution nonetheless)

XML for Analysis (abbreviated as XMLA) is an industry wellknown for records get entry to in analytical systems, consisting of OLAP and Data Mining. XMLA is primarily based on other industry requirements together with XML, SOAP and HTTP.

Question 46. Can You Change The Location Of Your Rpd File In Your Obiee Configuration? If Yes, Where Would You Mention The New Location Of This Rpd File For Bi Server?

Answer :

Read the NQSConfig document “Repository Section”. You will easily discover the answer. The solution for this is “It cant be changed”.

The repository vicinity may be modified, this should be carried out while clustering the BI Server. The parameters inside the NQSCONFIG.INI file are

REPOSITORY_PUBLISHING_DIRECTORY =

REQUIRE_PUBLISHING_DIRECTORY = YES;

Question forty seven. What Kind Of Joins Would You Perform In The Physical Layer Of The Repository File When Opened With Administration Tool?

Answer :

We cannot have outer joins in Physicla layer. We can outer joins in BMM layer.  In BMM layer – complicated be a part of can be complete internal be a part of or full outer be part of or something your standards turned into,but in physical layer – physical join is constantly an inner join.

Question forty eight. What Are The Minimum Services Needed To Load A Repository File Onto Memory And View A Dashboard Which Has Reports That Have Been Refreshed On A Scheduled Basis?

Answer :

Oracle BI Java Host, Oracle BI Presentation Server, and Oracle BI Server.

Question 49. What Is Level Based Metrics.How Will You Create It?

Answer :

Leval-base matrics approach, having a measure pinned at a certain level of the measurement. Monthly Total Sales or Quarterly Sales are the examples.

To create a level based totally measure, create a brand new logical column based totally on the original degree (like Sales in the instance above). Drag and drop the brand new logical column to the perfect stage within the Dimension hierarchy (in the above instance you will drag and drop it to Month in Time Dimension.

Question 50. What Are Global Filter And How They Differ From Column Filter?

Answer :

Column filter out- Simply a filter out applied on a column which we are able to use to restrict the our column values whilst pulling the information or in charts to see the associated content material.

Global clear out- This clear out could have effect on across the utility.

Question fifty one. What Is A Materialized View?

Answer :

Materialized view is a physical item and duplicate of the one or more master items.It will refresh in an durations.

Question fifty two. Have You Ever Tried With Denormalized Database To Build Reports? If Yes, How To Handle?

Answer :

Building reviews on denormalized records isn't always a first-class practice it results in performance troubles however we are able to construct the reports. These are reviews can’t be used for enterprise evaluation because the data will range non ordinary intervals.