Explore topic-wise InterviewSolutions in Current Affairs.

The RECORD will be REJECTED.

The record will be rejected.

UDA's VALUES are never displayed in the REPORTS and hence do not IMPACT report PERFORMANCE.

UDA's values are never displayed in the reports and hence do not impact report performance.

If we have a single processor, we will USE serial calculation but if we have MULTIPLE processors we can break the task into threads and MAKE them RUN on different processors.

If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.

In the process it CALCULATES more blocks than is NECESSARY. Sometimes it is necessary to PERFORM top-down calculation to GET the CORRECT calculation results.

In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

Lower LEVEL members and associated DATA remains in RELATIONAL database where as upper level members and associated data resides in ESSBASE database.

Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.

Three types of partitions are there.
1. TRANSPARENT partition: A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data SOURCE each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target USERS and transparent data source users.
2. Replicated Partition:
3. Linked Partition:

Three types of partitions are there.
1. Transparent partition: A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users.
2. Replicated Partition:
3. Linked Partition:

Yes

Yes

No.

No.

There will be no IMPACT on the DATABASE as the UDA’s doesn’t STORE DATA in the database.

There will be no impact on the database as the UDA’s doesn’t store data in the database.

1. GENERATION REFERENCES
2. LEVEL references
3. Parent-Child references

1. Generation references
2. Level references
3. Parent-Child references

They are specific objects LIKE FILES, CELL notes or URL's associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These LINKED objects are stored in the server. These LRO's can be exported or imported with the database for backup and migration activities.

They are specific objects like files, cell notes or URL's associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO's can be exported or imported with the database for backup and migration activities.

Yes

Yes

PK&FK based on ROW_ID are used for system wide referential integrity. Based on multiple COLUMNS user keys are used to uniquely IDENTIFY a row for EIM.

PK&FK based on ROW_ID are used for system wide referential integrity. Based on multiple columns user keys are used to uniquely identify a row for EIM.

DATA Mapping determines
–Which SIEBEL base table columns will store external SOURCE data
–Which INTERFACE table columns will be used to import from source to destination.

Data Mapping determines
–Which Siebel base table columns will store external source data
–Which interface table columns will be used to import from source to destination.

During IMPORTS, EIM attempts to import DATA from the INTERFACE table to the base table. It is important to note that if the data loaded in the interface table is faulty, it will remain faulty in the base tables. EIM Does not perform data CLEANSING.

During imports, EIM attempts to import data from the interface table to the base table. It is important to note that if the data loaded in the interface table is faulty, it will remain faulty in the base tables. EIM Does not perform data cleansing.

Interface TABLES store external data inside the Siebel database.
These tables are:
Staging area for data to be imported, updated merged in to base tables via EIM.
Staging area for data exported by EIM.
Staging area for data to be DELETED in the base table using EIM’s DELETE EXACT CLAUSE.

Interface tables store external data inside the Siebel database.
These tables are:
Staging area for data to be imported, updated merged in to base tables via EIM.
Staging area for data exported by EIM.
Staging area for data to be deleted in the base table using EIM’s DELETE EXACT CLAUSE.

The User data is stored in one or more base tables in the Siebel DATABASE. Relationship between the base tables RELAY UPON PK & FK based on row ids.
-ROW_ID is the SYSTEM primary key for every base table.
-ROW_ID is the system-generated value.

The User data is stored in one or more base tables in the Siebel database. Relationship between the base tables relay upon PK & FK based on row ids.
-ROW_ID is the system primary key for every base table.
-ROW_ID is the system-generated value.

EIM Deletes are useful for archiving OLD DATA and deleting obsolete data. During DELETE processing the deleted rows are written to interface tables from which they can be ARCHIVED in a format allowing easy re IMPACT if necessary.

EIM Deletes are useful for archiving old data and deleting obsolete data. During delete processing the deleted rows are written to interface tables from which they can be archived in a format allowing easy re impact if necessary.

STANDARD and CUSTOM EXTENSIONS

Standard and Custom extensions

EIM: It is batch MODE Integration. When data volume is large then we have to GO to EIM.
EAI: It is REAL time Integration. When data volume is small then we have to go to EAI.

EIM: It is batch mode Integration. When data volume is large then we have to go to EIM.
EAI: It is real time Integration. When data volume is small then we have to go to EAI.

USER data only MANAGED and populated by you. INSTALLATION populates seed data and REPOSITORY data.

User data only managed and populated by you. Installation populates seed data and repository data.

EIM is a server task that manages exchange of data between external data in INTERFACE TABLES and user data in BASE tables.

EIM is a server task that manages exchange of data between external data in interface tables and user data in base tables.

EAI is a INTEGRATION method for INTEGRATING the applications within your organization. There is another KIND of integration called B2B. It is of two forms i.e Extended enterprise EE and market B2B.

There are DIFFERENT categories of EAI i.e DATA level oriented, Application level oriented, Method oriented, portal oriented and process oriented.

EAI is a integration method for integrating the applications within your organization. There is another kind of integration called B2B. It is of two forms i.e Extended enterprise EE and market B2B.

There are different categories of EAI i.e Data level oriented, Application level oriented, Method oriented, portal oriented and process oriented.

BUSINESS SERVICES and WORKFLOWS Both
Business Services Only
WORKFLOW Only

Business Services and Workflows Both
Business Services Only
Workflow Only

FIRST RECORD of Actioin BC
* (a STAR CHARACTER)

First Record of Actioin BC
* (a star character)

USING ‘EAI XSLT Service’ Business Service
Using ‘PRM ANI UTILITIES’ Business Service
Using ‘EAI DATA Transformation Engine’ Business Service.

Using ‘EAI XSLT Service’ Business Service
Using ‘PRM ANI Utilities’ Business Service
Using ‘EAI Data Transformation Engine’ Business Service.

BUSINESS SERVICE
WEB SERVICES
WORKFLOW

Business Service
Web Services
Workflow

SYNC
ASYNC
DirectDB

Sync
Async
DirectDB

Child BC is ADDED in the BO via a LINK
A MVL is created in the Parent BC connecting to Child

Child BC is added in the BO via a Link
A MVL is created in the Parent BC connecting to Child

Base Table User KEYS
MOD ID and ROW Id of IC's
IC User Keys

Base Table User Keys
Mod Id and Row Id of IC's
IC User Keys

SIEBEL Business OBJECT
XML
SQL DATABASE Wizard

Siebel Business Object
XML
SQL Database Wizard

INBOUND WEB SERVICE
OUTBOUND Web Service

Inbound Web Service
Outbound Web Service

EAI Siebel ADAPTER
EAI UI DATA Adapter
EAI MQ SERIES Server TRANSPORT

EAI Siebel Adapter
EAI UI Data Adapter
EAI MQ Series Server Transport

• SQL Server Integration SERVICES:- Used for data transformation and creation. Used in data acquisition form a source system.
• SQL Server Analysis Services: Allows data discovery using data mining. Using BUSINESS logic it supports data enhancement.
• SQL Server REPORTING Services:- Used for Data presentation and distribution ACCESS.

• SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.
• SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.
• SQL Server Reporting Services:- Used for Data presentation and distribution access.

SAS BUSINESS intelligence has analytical capabilities like statistics, reporting, DATA mining, predictions, FORE casting and optimization. They help in getting data in the FORMAT DESIRED. It helps in improving quality of data.

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, fore casting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

A dashboard in business intellgence allows huge DATA and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a GLANCE. They can also be USED to get into details of this data to ANALYZE the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to KNOW how much cash is deposited, how much is left etc.

A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a BETTER understanding of data.Business intelligence can be considered as the collective information. It helps in making predictions of business operations using GATHERED data in a warehouse. Business intelligence application helps to tackle sales, FINANCIAL, production etc business data. It helps in a better decision making and can be also considered as a decision SUPPORT system.

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a better understanding of data.Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle sales, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

Online Mode- You can MAKE changes in the RPD file and push in changes which will be immediately visible to the users who are already connected. This feature we MAY use in production ENVIRONMENT.
Offline mode- can be USEFUL in test or development environment.

Online Mode- You can make changes in the RPD file and push in changes which will be immediately visible to the users who are already connected. This feature we may use in production environment.
Offline mode- can be useful in test or development environment.

RPD USERS can do administrator tasks like adding new DATA source, create hirarchies, change column names where as Answers users may create new CHARTS, edit those charts and Dashboard users may only view and analyse the dashboard or can edit dashboard by adding/removing charts OBJECTS.

RPD users can do administrator tasks like adding new data source, create hirarchies, change column names where as Answers users may create new charts, edit those charts and Dashboard users may only view and analyse the dashboard or can edit dashboard by adding/removing charts objects.

I think it is just the ARRANGEMENT of HYPERLINKS to GUIDE the user to NAVIGATE between the REPORTS to do the analysis.

I think it is just the arrangement of hyperlinks to guide the user to navigate between the reports to do the analysis.

while creating a CHAT in BI Answers, you can DEFINE the CONDITIONS and can apply COLOUR formatting.

while creating a chat in BI Answers, you can define the conditions and can apply colour formatting.

No

No

To enable Drill down for a column, it should be included in the hirarchy in OBIEE. Hyperion IR has a drill ANYWHERE FEATURE where DONT have to define and can drill to any AVAILABLE column.

To enable Drill down for a column, it should be included in the hirarchy in OBIEE. Hyperion IR has a drill anywhere feature where dont have to define and can drill to any available column.

Application ACCESS LEVEL security- Do not add the COLUMN in the report, Do not add the column in the presentation LAYER.

Application access level security- Do not add the column in the report, Do not add the column in the presentation layer.

We CONFIGURE the OBIEE SCHEDULAR in DATABASE.

We configure the OBIEE schedular in database.

Column filter- SIMPLY a filter applied on a column which we can use to restrict our column values while PULLING the DATA or in charts to see the related CONTENT.

Global filter- Not sure. I UNDERSTAND this filter will have impact on across the application but I really dont understand where and how it can be user. I heard of global variables but not global filters.

Column filter- simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.

Global filter- Not sure. I understand this filter will have impact on across the application but I really dont understand where and how it can be user. I heard of global variables but not global filters.

Every now and then there are PROBLEMS with the database connections but the problem while creating the repository RPD files comes with complex schemas made on OLTP systems consisting of LOT of joins and checking the RESULTS. TH type of join made need to be checked. By default it is inner join but sometimes the requirement demands other types of joins. There are lot of problems with the DATE formats also.

Every now and then there are problems with the database connections but the problem while creating the repository RPD files comes with complex schemas made on OLTP systems consisting of lot of joins and checking the results. Th type of join made need to be checked. By default it is inner join but sometimes the requirement demands other types of joins. There are lot of problems with the date formats also.

The logical SQL generated by the SERVER can be viewed in BI Answers. If I have not UNDERSTOOD the question, Please RAISE your voice.

The logical SQL generated by the server can be viewed in BI Answers. If I have not understood the question, Please raise your voice.

Some of the STANDARD Business Intelligence tools in the market ACCORDING to there 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 there performance
1)MICROSTRATEGY
2)BUSINESS OBJECTS,CRYSTAL REPORTS
3)COGNOS REPORT NET
4)MS-OLAP SERVICES.

We can CONNECT Ab Initio GDE with CO>operating system using Run->Settings.In there u can specify the HOST IP ADDRESS and the connection type .REFER Ab Initio help for further details.

We can connect Ab Initio GDE with Co>operating system using Run->Settings.In there u can specify the host IP address and the connection type .Refer Ab Initio help for further details.