Explore topic-wise InterviewSolutions in Current Affairs.

Casual dimension is a dimension that should not change the fundamental grain of a fact table.
Ex: SEX- Male, Female.

Casual dimension is a dimension that should not change the fundamental grain of a fact table.
Ex: sex- Male, Female.

The input CONTEXT DETERMINES what dimension to go into the calculations to produce the values. Whereas the out put context determines how the values are combined. It is generated by the CELL LOCATION with the report.

The input context determines what dimension to go into the calculations to produce the values. Whereas the out put context determines how the values are combined. It is generated by the cell location with the report.

Objects created USING SQL queries or STORED procedures CALLED Degenerated Objects.

Objects created using SQL queries or stored procedures called Degenerated Objects.

The computation ERROR is related to the MISUSE of context operators in FORMULA.

The computation error is related to the misuse of context operators in formula.

There are 2ways to migrate 6.5 to xi.
1) Open migrate wizard. IMPORT WIZARD WINDOW appears. Import wizard is a tool to migrate reports, Universes, Repository OBJECTS to ONE environment to other environment with in XI and also from prior versions to XIR2 versions.
2) While using this option, Report Conversion tool.

There are 2ways to migrate 6.5 to xi.
1) Open migrate wizard. IMPORT WIZARD window appears. Import wizard is a tool to migrate reports, Universes, Repository objects to one environment to other environment with in XI and also from prior versions to XIR2 versions.
2) While using this option, Report Conversion tool.

There are some THIRD party SOFTWARE are there to connect LIKE "CITRIX".

There are some third party software are there to connect like "CITRIX".

a) Go to Definition tab in the DATA manager there u FIND these query options.
b) Before run a REPORT just click on VIEW button u can see the report.
c) Simple! Take the report query and modify to take the count in the query and execute it at the back END.

a) Go to Definition tab in the data manager there u find these query options.
b) Before run a report just click on view button u can see the report.
c) Simple! Take the report query and modify to take the count in the query and execute it at the back end.

a) From the data manager tab we can know the no of rows RETURNED and the time taken to run the report.
B) Click on any column in result SET, right click and select count all. This will display the total NUMBER of columns in the result set.

a) From the data manager tab we can know the no of rows returned and the time taken to run the report.
b) Click on any column in result set, right click and select count all. This will display the total number of columns in the result set.

Join PROBLEMS are ANALYZED by INTEGRITY CHECKING and resolve by setting cardinalities.

Join problems are analyzed by Integrity checking and resolve by setting cardinalities.

Zero-CLIENT viewers do not REQUIRE client-side software to be installed or downloaded. INSTEAD these viewers display the REPORTS as DHTML.

Thin Client Viewers require components to be downloaded and installed on the client‟s computers. These client viewers offers better report fidelity but can require more administrative overhead.

Zero-client viewers do not require client-side software to be installed or downloaded. Instead these viewers display the reports as DHTML.

Thin Client Viewers require components to be downloaded and installed on the client‟s computers. These client viewers offers better report fidelity but can require more administrative overhead.

We can secure the universe by APPLYING SECURITY restrictions through Universe Designer.
We can APPLY following types of security restrictions on different users:
1. OBJECT Restriction
2. Row Level Restriction.
3. Table Mapping.
4. Connection Restriction.

We can secure the universe by applying security restrictions through Universe Designer.
We can apply following types of security restrictions on different users:
1. Object Restriction
2. Row Level Restriction.
3. Table Mapping.
4. Connection Restriction.

By MOVING it as a FILE through the file SERVER and EXPORTING it to the REPOSITORY.

By moving it as a file through the file server and exporting it to the repository.

folders: folders and subfolders are used to organize documents
categories: categories are a WAY to classify your information
for example, you COULD place your financial reports and documents into a FOLDER name FINANCE and you could classify or tag your reports that deal with SPECIFIC financial matters as payroll, accounts, payble and accounts receivable.

folders: folders and subfolders are used to organize documents
categories: categories are a way to classify your information
for example, you could place your financial reports and documents into a folder name finance and you could classify or tag your reports that deal with specific financial matters as payroll, accounts, payble and accounts receivable.

I believe you can DEFINE a formula LIKE below
Not ISNULL(object). This formula should bypass all records that has NULL VALUES..There might be some other ways too..

I believe you can define a formula like below
Not IsNull(object). This formula should bypass all records that has null values..There might be some other ways too..

1. Two Universe
2. Depends on my data base and my project. example.in my project if i have 100 TABLES i will create 6 universe.
Any way u have a two years of exp in BO .u dont have chance to create universe.we NEED min 5 to 6 + exp and good domain knowledge.

1. Two Universe
2. Depends on my data base and my project. example.in my project if i have 100 tables i will create 6 universe.
Any way u have a two years of exp in bO .u dont have chance to create universe.we need min 5 to 6 + exp and good domain knowledge.

Business VIEW is used to create a lovs in crystal reports. This can be schedule to refresh to daily. business view can be used by only in crystal reports a universe can also be a SOURCE for crystal reports as well as web intelligence. in business view we can connect to MULTIPLE database and create a business view, it is not there in universe.

Business view is used to create a lovs in crystal reports. This can be schedule to refresh to daily. business view can be used by only in crystal reports a universe can also be a source for crystal reports as well as web intelligence. in business view we can connect to multiple database and create a business view, it is not there in universe.

DASHBOARDS is NOTHING but COLLECTION of INFORMATION.

Dashboards is nothing but collection of information.

A metric is the MEASURE of ACTUAL PERFORMANCE. A metric is defined using OBJECTS in the universe. These are USED to track trends and productivity.

A metric is the measure of actual performance. A metric is defined using objects in the universe. These are used to track trends and productivity.

CUSTOM sorting is nothing but sorting as PER our requirement suppose MONTHS like
jan
feb
mar
apr
may
jun
jul
We can DISPLAY first jan next mar next jun for these purpose we can use custom sort.

Custom sorting is nothing but sorting as per our requirement suppose months like
jan
feb
mar
apr
may
jun
jul
We can display first jan next mar next jun for these purpose we can use custom sort.

We can do this in 2 LEVELS in BO.
1. In UNIVERSE parameters, set the no of RECORDS for your requirements.
But I will apply to all reports.
2. We can do this to a particular report in the query panel.
Select OPTION button (Left side down placed) and set the no of records how many you WANT.

We can do this in 2 levels in BO.
1. In Universe parameters, set the no of records for your requirements.
But I will apply to all reports.
2. We can do this to a particular report in the query panel.
Select OPTION button (Left side down placed) and set the no of records how many you want.

Go to FORMAT--Sorts then CLICK on Add. We will GET all the objects select the object and APPLY it which is not in the Cross tab REPORT.

Go to Format--Sorts then click on Add. We will get all the objects select the object and apply it which is not in the Cross tab report.

FULL PATH CLIENT is NOTHING but an info-view.

Full path client is nothing but an info-view.

merged dimension is nothing but to synchronize the data from different data sources with a common dimension.

Web Intelligence ALLOWS you to synchronize multiple data PROVIDERS in the same document. This allows you to build reports which synchronize data from multiple sources. When you synchronize QUERIES through MERGING, you can include report OBJECTS from different queries in the same report block.

merged dimension is nothing but to synchronize the data from different data sources with a common dimension.

Web Intelligence allows you to synchronize multiple data providers in the same document. This allows you to build reports which synchronize data from multiple sources. When you synchronize queries through merging, you can include report objects from different queries in the same report block.

HIDE the colomn ---

menu>formate>table formate>pivote>hide BUTTON, Rows can be hide only when the break is APPLIED on a particular COLUMN using...

Format-->Breaks-->Fold.

hide the colomn ---

menu>formate>table formate>pivote>hide button, Rows can be hide only when the break is applied on a particular column using...

Format-->Breaks-->Fold.

By USING data SYNCHRONIZATION Option.... synchronization is the term USED to describe the merging of data from multiple data sources into a SINGLE BLOCK in a report.

By using data synchronization Option.... synchronization is the term used to describe the merging of data from multiple data sources into a single block in a report.

The main fact behind creating universes is "Business users need not have strong SQL back ground. But sometimes they need to develop reports". In such case the importance of universe COMES. The universe designer needs to have a strong SQL back ground and he/she will create universe which in turn has objects like DIMENSIONS, measures, etc,...

The business USER then USES these objects just by dragging and dropping in the QUERY editor pane. Dragging, dropping and running is more easy for him rather than writing SQL by his own.

The main fact behind creating universes is "Business users need not have strong SQL back ground. But sometimes they need to develop reports". In such case the importance of universe comes. The universe designer needs to have a strong SQL back ground and he/she will create universe which in turn has objects like dimensions, measures, etc,...

The business user then uses these objects just by dragging and dropping in the query editor pane. Dragging, dropping and running is more easy for him rather than writing SQL by his own.

Shared connection
Secured connection
Personal connection - USED only STAND alone SYSTEM.

Shared connection
Secured connection
Personal connection - used only stand alone system.

INNER JOIN, outerjoin, left, RIGHT outer join, FULL outer Join.

Inner Join, outerjoin, left, right outer join, full outer Join.

In a SCHEMA we have only one look loop u can create Alias. But, when we have MULTIPLE look up u can create contexts. most of the cases are using CONTEXT can be use to resolve the loops. why because more NUMBER of complexity loops and also schema contains 2 or more fact TABLES in ur universe design. If there are more than one fact table use a context or if only one fact table use alias.

In a schema we have only one look loop u can create Alias. But, when we have multiple look up u can create contexts. most of the cases are using context can be use to resolve the loops. why because more number of complexity loops and also schema contains 2 or more fact tables in ur universe design. If there are more than one fact table use a context or if only one fact table use alias.

By CREATING the SUMMARY TABLES and USING aggregate AWARENESS.

By creating the summary tables and using aggregate awareness.

for each-add all OBJECTS to the contex
for all-delete all objects from the CONTEXT
we USE forall for summary purpose and FOREACH for detail purpose.

for each-add all objects to the contex
for all-delete all objects from the context
we use forall for summary purpose and foreach for detail purpose.

When the contexts are not PROPERLY defined we will get the ERROR as incompaitable COMBINATION of OBJECTS.

When the contexts are not properly defined we will get the error as incompaitable combination of objects.

WHENEVER we EXECUTE the formula , the result will be STORED in the VARIABLE.

Whenever we execute the formula , the result will be stored in the variable.

It DEPENDS upon the Database limits provided to define the Foreign key constraint, e.g. in SQL Server 2005, the recommended max limit for foreign KEYS is 253, but you can define more.

It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Some of the standard Business INTELLIGENCE tools in the market According to their performance
1)MICROSTRATEGY
2)BUSINESS OBJECTS,CRYSTAL REPORTS
3)COGNOS REPORT NET
4)MS-OLAP SERVICES.

Some of the standard Business Intelligence tools in the market According to their performance
1)MICROSTRATEGY
2)BUSINESS OBJECTS,CRYSTAL REPORTS
3)COGNOS REPORT NET
4)MS-OLAP SERVICES.

Surrogate KEY is a PRIMARY Key for a Dimension table. Most importance of USING it is it is independent of UNDERLYING database. i.e Surrogate Key is not affected by the changes GOING on with a database.

Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.

CONFIG FILE consists of the following.

a) NUMBER of Processes or Nodes.
B) Actual Disk STORAGE Location.

Config file consists of the following.

a) Number of Processes or Nodes.
b) Actual Disk Storage Location.

Four Places you can call

(i) Transform of routine

• Date TRANSFORMATION
• Upstring Transformation

(ii) Transform of the Before & After Subroutines
(III) XML transformation
(IV)WEB base.

Four Places you can call

(i) Transform of routine

(ii) Transform of the Before & After Subroutines
(iii) XML transformation
(iv)Web base.

In ALMOST all CASES we have to delete the data inserted by this from DB MANUALLY and FIX the JOB and then run the job again.

In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.

CURRENTLY, the total is converted to ASCII, even tho the individual RECORDS are stored as EBCDIC.

Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.

ODBC :
a) POOR Performance.
b) Can be used for Variety of Databases.
C) Can handle Stored PROCEDURES.
Plug-In: a) GOOD Performance. b) DATABASE specific.(Only one database)

ODBC :
a) Poor Performance.
b) Can be used for Variety of Databases.
c) Can handle Stored Procedures.
Plug-In: a) Good Performance. b) Database specific.(Only one database)

Containers : Usage and TYPES?

Containers is a COLLECTION of STAGES used for the purpose of Reusability. There are 2 types of Containers.

a) Local CONTAINER: Job Specific
b) Shared Container: Used in any job within a project.

Containers : Usage and Types?

Containers is a collection of stages used for the purpose of Reusability. There are 2 types of Containers.

a) Local Container: Job Specific
b) Shared Container: Used in any job within a project.

Data Modelling is Broadly classified into 2 TYPES.

a) E-R Diagrams (ENTITY - Relatioships).
b) DIMENSIONAL Modelling.

Data Modelling is Broadly classified into 2 types.

a) E-R Diagrams (Entity - Relatioships).
b) Dimensional Modelling.

Always parameterized the JOB. EITHER the VALUES are COMING from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some PARAMETERS in your jobs.

Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters in your jobs.

Most of the times the DATA was sent to US in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we USED ODBC drive.

Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drive.

TRANSFORMER, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, HASH, ODBC, AGGREGATOR, SORT.

Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort.

100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it NEED not be the same NUMBER for everybody.

100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody.

Yes. The following are some of the steps; I have taken in doing so:
1) Definitely take a back up of the WHOLE project(s) by exporting the project as a .dsx FILE.
2) See that you are USING the same parent.

Yes. The following are some of the steps; I have taken in doing so:
1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file.
2) See that you are using the same parent.

USED for Look-ups. It is LIKE a REFERENCE table. It is also used in-place of ODBC, OCI tables for BETTER PERFORMANCE.

Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.

As the names itself suggest what they mean. In general we USE Type-30 DYNAMIC HASH files. The Data file has a DEFAULT size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.