Interview Questions.

Q1. Can We Create Reports Without Creating Universe?

Yes we can create reviews with out developing Universe.

Q2. What Is Power Center Repository?

PC Repository is a relational database that shops the metadata describes different gadgets like mapping and trformation. This is controlled by repository carrier.

Q3. How Can We Use Pmcmd Command In A Workflow Or To Run A Session

pmcmd>startworkflow -f foldername workflowname

Q4. Is Microstrategy Desktop Available In Other Languages?

Microstrategy Desktop is available in English, French, German, Spanish, Korean, Italian, Swedish, Japanese and Portuguese.

Q5. What Is A Private Synonyms?

A Private Synonyms can be accessed best via the proprietor.

Q6. What Is The Difference Between Eim And Eai?

EIM: It is batch mode Integration. When data quantity is huge then we must go to EIM.

EAI: It is real time Integration. When statistics volume is small then we ought to go to EAI.

Q7. Compare And Contrast Odbc And Plug-in Stages?

ODBC :

a) Poor Performance.

B) Can be used for Variety of Databases.

C) Can take care of Stored Procedures.

Plug-In: a) Good Performance. B) Database particular.(Only one database)

Q8. How Do We Design A Universe?

The layout approach includes  fundamental levels.

During the first section, you create the underlying database shape of your universe. This shape includes the tables and columns of a database and the joins by means of which they may be linked. You might also want to clear up loops which arise within the joins using aliases or contexts. You can conclude this segment with the aid of testing the integrity of the general shape.

During the second one segment, you may proceed to beautify the components of your universe. You can also put together certain items for multidimensional evaluation. As with the primary phase, you must check the integrity of your universe structure. You may also wish to perform assessments at the universes you create from the BusinessObjects User module. Finally, you could distribute your universes to users by exporting them to the repository or via your report system.

For a universe based totally on a easy relational schema, Designer gives Quick Design, a wizard for developing a simple but entire universe. You can use the ensuing universe immediately, or you can alter the items and create complex new ones. In this manner, you may progressively refine the best and structure of your universe.

Q9. How Would You Find Out Whether A Sql Query Is Using The Indices You Expect?

Explain plan may be reviewed to check the execution plan of the question. This would manual if the anticipated indexes are used or not.

Q10. Explain About The Functionality Of Olap?

Hyper cube or multidimensional cube paperwork the center of OLAP gadget. This includes measures that are organized according to dimensions. Hyper cube Meta data is created by using big name or snow flake schema of tables in RDBMS. Dimensions are extracted from measurement table and measures from the truth desk.

Q11. What Are Lookup Tables?

A research table is the table placed on the goal table based totally upon the number one key of the target, it simply updates the table by permitting simplest changed (new or up to date) records based totally on thelookup condition.

Q12. What Are Fact, Dimension, And Measure?

Fact is prime overall performance indicator to investigate the business. Dimension is used to research the reality. Without dimension there's no which means for fact.

Q13. Is Oltp Database Is Design Optimal For Data Warehouse?

No. OLTP database tables are normalized and it's going to upload overtime to queries to go back results. Additionally OLTP database is smaller and it does no longer incorporate longer period (a few years) information, which needs to be analyzed. A OLTP machine is largely ER model and now not Dimensional Model. If a complex query is finished on a OLTP system, it is able to motive a heavy overhead at the OLTP server a good way to have an effect on the regular enterprise techniques.

Q14. What Are Passthrough Functions?

Pass via features are used to make use of numerous unique capabilities that specific to databases.Some of the passthrough functions to be had are Applysimple and Applycomparision.

Q15. Explain The Dashboard In The Business Intelligence.

A dashboard in commercial enterprise intellgence permits big statistics and reports to be read in a unmarried graphical interface. They help in making quicker choices by using replying on measurable statistics seen at a glance. They also can be used to get into info of this records to investigate the basis cause of any commercial enterprise overall performance. It represents the business statistics and commercial enterprise country at a excessive level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run hundreds of ATM’s. They want to know how an awful lot coins is deposited, how a lot is left and so on.

Q16. What Are The Universe Connection Types?

Shared connection

Secured connection

Personal connection - used most effective stand alone machine.

Q17. Define Informatica Repository?

Infromatica Repository:The informatica repository is at the middle of the informatica suite. You create a hard and fast of metadata tables inside the repository database that the informatica software and gear get right of entry to. The informatica purchaser and server access the repository to save and retrieve metadata.

Q18. What Is The Latest Version That Is Available In Ab-initio?

The trendy version of GDE ism1.15 AND Co>working gadget is two.14.

Q19. What Kind Of Tool Bo Is?

A) Bo is a reporting tool to Query the database or information warehouse.

B) Bo is a query, reporting and analysis tool.

C) Bo is an OLAP device. (ROLAP)

Q20. How You Worked With Multiple Data Sources?If Yes ?How Do You Link Them?

You could create exceptional universe for one of a kind resources and link them in BO.

Q21. Say, The Query Gets Executed And We Got The Results. In Case If We Have A Large Number Of Rows, How Can We Know The Exact No Of Rows Returned?

A) From the facts manager tab we are able to realize the no of rows returned and the time taken to run the record.

B) Click on any column in end result set, proper click on and pick matter all. This will display the full quantity of columns within the result set.

Q22. What Are Cartesian Joins?

A Cartesian be a part of gets you a Cartesian product. A Cartesian join is while you join every row of 1 table to every row of some other desk. You also can get one by becoming a member of every row of a desk to each row of itself.

Q23. What Is Functionality Of Link Partitioner And Link Collector?

Containers : Usage and Types?

Containers is a group of ranges used for the cause of Reusability. There are 2 styles of Containers.

A) Local Container: Job Specific

b) Shared Container: Used in any job within a undertaking.

Q24. What Are The Different Types Of Tractions Tibco Provides?

TIBCO BusinessWorks offers a ramification of styles of tractions that may be used in different conditions. You can use the type of traction that fits the desires of your integration venture. When you create a traction organization, you need to specify the type of traction. TIBCO BusinessWorks supports the subsequent types of tractions:

• JDBC

• Java Traction API (JTA) UserTraction

• XA Traction.

Q25. How Does Maxcore Works?

Maxcore is a cost (it is going to be in Kb).Whne ever a factor is achieved it will take that a good deal memeory we unique for execution.

Q26. How To Design A Process Such That Depending On Number Of Records Updated In A Database, three Different Sub-procedures May Be Called ?

Define three tritions from JDBC update with situation on the no of updates and speak to appropriate child procedures.

Q27. What Are Slowly Changing Dimensions?

Dimensions that trade over the years are referred to as Slowly Changing Dimensions. For example, a product charge adjustments over time; People alternate their names for some cause; Country and State names might also change through the years. These are some examples of Slowly Changing Dimensions seeing that some adjustments are going on to them over a period of time.

If the statistics in the Dimension table show up to trade very rarely,then it's far referred to as as slowly converting measurement.

Ex: changing the name and address of a person,which happens rerely.

Q28. What Is Difference Between Drill & Scope Of Analysis?

Drilling may be performed in drill down, up, via, and across; scope is the overall view of the drill exercise.

Q29. Are There Any Special Requirements Needed To Move Objects Across Projects?

Yes. In order to perform go-undertaking operations, the tasks involved ought to originate from the equal source undertaking. In other phrases, the tasks can best be related by the duplication of a single undertaking. This ensures that the tasks have a similar set of schema and alertness gadgets, and that the item ID's inside the  projects are the identical. MicroStrategy Object Manager makes use of the object and model ID's across the projects to perform comparisons. MicroStrategy Object Manager prevents the person from trying operations across unrelated tasks.

Q30. What Is M_dump?

M_dump command prints the records in a formatted way.

M_dump

Q31. What Is A General Purpose Scheduling Tool?

The simple motive of the scheduling tool in a DW Application is to circulation line the glide of facts from Source To Target at precise time or based on a few condition.

Q32. What Is The Difference Between A Cascading Report And Drillthru Report?Why Do We Go For Drill Thru Report?

Cascading report works based totally on the circumstance however drill through paintings primarily based on the facts item what we pick out as a drill via alternatives.

Q33. What Is Surrogate Key? Where We Use It? Explain With Examples.

Surrogate key's a substitution for the natural primary key.It is just a completely unique identifier or range for each row that may be used for the number one key to the desk. The best requirement for a surrogate number one secret's that it's miles particular for each row within the table.

Data warehouses commonly use a surrogate, (additionally called synthetic or identification key), key for the dimension tables primary keys. They can use Info collection generator, or Oracle collection, or SQL Server Identity values for the surrogate key.

It is beneficial due to the fact the herbal primary key (i.E. Customer Number in Customer desk) can exchange and this makes updates extra hard.

Some tables have columns along with AIRPORT_NAME OR CITY_NAME which are stated as the number one keys (consistent with the enterprise customers) however ,now not most effective can these change, indexing on a numerical value is probably better and you may bear in mind developing a surrogate key called, say, AIRPORT_ID. This might be inner to the system and as some distance because the customer is involved, you could show most effective the AIRPORT_NAME.

Q34. What Is A Security Filter?

Security filter out is used to use safety on the database facts level.Whenever a users related to security clear out runs a document, a WHERE clause is usually protected within the report square with the condition described inside the Security Filter.

Q35. What Is Er Diagram?

The Entity-Relationship (ER) version was at the beginning proposed through Peter in 1976 [Chen76] as a way to unify the network and relational database views. Simply stated the ER model is a conceptual information model that views the actual world as entities and relationships. A fundamental component of the version is the Entity-Relationship diagram, which is used to visually represent information objects. Since Chen wrote his paper the version has been prolonged and these days it's far commonly used for database design for the database fashion designer, the utility of the ER version is: it maps nicely to the relational model. The constructs used in the ER version can without difficulty be trformed into relational tables. It is easy and clean to understand with no less than education. Therefore, the database clothier to talk the layout to the cease consumer can use the version. In addition, the model can be used as a layout plan through the database developer to put into effect a information version in specific database control software program.

Q36. Which Siebel Tools Objects Can Be Published As Web Services?

Business Services and Workflows Both

Business Services Only

Workflow Only

Q37. Can We Have Multiple Domains?

Yes.

We've got a couple of domains,but security domain isn't more than one,handiest file area and universe domain is a couple of.

Q38. What Are Dashboards?

A management reporting tool to gauge how well the employer company is performing. It normally makes use of "site visitors-lighting fixtures" or "smiley faces" to decide the status.

Q39. What Is Data Analysis? Where It Will Be Used?

Data evaluation: take into account which you are jogging a commercial enterprise and u save the statistics of that; in some form say in sign up or in a comp and at the yr give up you want understand the income or loss then it called records evaluation .Data analysis use: then u need to realize which product changed into sold the very best and if the business is jogging in a loss then finding, in which we went incorrect we do evaluation.

Q40. What Is A Cube In Data Warehousing Concept?

Cubes are logical representation of multidimensional data. The fringe of the dice includes size members and the body of the cube includes facts values.

Q41. What Are Different Types Of Attributes?

Essbase helps  unique sorts of attributes.

@User-Defined attributes

@Simple attributes

User-Defined attributes: The attributes that are described by means of the consumer.

Simple attributes: Essbase helps some attributes, they're: Boolean, date, variety, and string.

Q42. What Is The Difference Between Active Trformation And Passive Trformation?

An lively trformation can exchange the wide variety of rows that bypass via it, but a passive trformation can not change the number of rows that skip via it.

Q43. What Is A Real-time Data Warehouse? How Is It Different From Near To Real-time Data Warehouse?

As the term shows, a real-time statistics warehouse is a device, which reflects all adjustments to its sources in actual time. As simple as it sounds, this is nonetheless an area of active studies inside the discipline. In conventional DWH, the operational machine(s) are stored become independent from the DWH for a terrific reason.

The Operational systems are designed to simply accept inputs or modifications to statistics regularly, for this reason have an awesome threat of being regularly queried. On the other hand, a DWH is meant to do simply the alternative - it is used to query statistics for reports only. No modifications to information, through consumer actions is predicted (or designed). The only inputs ought to come from the ETL feed at stipulated instances. The ETL would source its statistics from the Operational systems simply explained above.

To create a real-time DWH we might ought to merge each systems (several methods are being explored), a idea this is towards the purpose of making a DWH. Bigger challenges arise in terms of updating aggregated information in data at real time, nonetheless preserving the surrogate keys.

Besides, we might need lightening rapid hardware to try this.Near Real time DWH is a trade-off between the traditional layout and the dream of all customers nowadays. The frequency of ETL updates in higher in this case for e.G. Once in 2 hours. We also can examine and use selective refreshes at shorter time intervals, whilst complete refreshes may still be kept similarly aside. Selective refreshes might have a look at handiest those tables that get up to date regularly.

Q44. What Is The Advantages Data Mining Over Traditional Approaches?

Data Mining is used for the estimation of future. For example, if we take a agency/enterprise business enterprise, through the use of the concept of Data Mining, we will predict the future of commercial enterprise in terms of Revenue (or) Employees (or) Customers (or) Orders and so forth.Traditional procedures use simple algorithms for estimating the destiny. However, it does now not give accurate outcomes when in comparison to Data Mining.

Q45. What Kinds Of Information Can Users Receive?

Users can receive each tables and charts from the Microstrategy platform, and content material from present day records assets including traction processing structures, Enterprise Resource Planning systems, databases, XML documents, and web servers.

Q46. How To Spot A Hierarchy?

From the fashion designer u can spot the already referred to hierarchy and additionally u can trade or edit the same.

Go to Tool->Hierarchies

Here u can ether add a brand new one or also can edit the present one.

Q47. What Does A Config File In Parallel Extender Consist Of?

Config document includes the subsequent.

A) Number of Processes or Nodes.

B) Actual Disk Storage Location.

Q48. How Do You Convert 4-way Mfs To eight-way Mfs?

To convert four way to eight way partition we need to exchange the format within the partioning aspect. There could be seperate parameters for each and every form of partioning eg. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME etc.

The appropriate parameter want to be decided on in the aspect format for the kind of partioning.

Q49. Types Of Partitions Available In Essbase?

Three styles of walls are there.

@Trparent partition: A shape of shared partition that offers the potential to access and control faraway data trparently as though it's miles part of your local database. The far flung information is retrieved from the statistics supply every time you request it. Any updates made to the statistics are written again to the facts source and come to be at once reachable to each local information goal customers and trparent statistics source users.

@Replicated Partition:

@Linked Partition:

Q50. What Is The Difference Between Star And Snowflake Schemas?

Star schema:

A unmarried reality desk with N variety of DimensionSnowflake schema: Any dimensions with extended dimensions are referred to as snowflake schema.