DataStage Interview Questions

Ans. MOLAP tools utilize a pre-calculated data set, commonly referred to as a data cube and MOLAP systems gives fast response. MOLAP systems are generally used for bounded problem set. ROLAP tools are best used for users who have “unbounded” problem set . ROLAP tools do not use pre-calculated data cubes. Instead, queries the standard […]

Continue reading about What are the major differences between MOLAP (multidimensional OLAP) and ROLAP(relational OLAP) ?

Data in the data mart is refreshed in accordance with the predetermined frequency schedule established by the Project Manager. Within BusinessObjects, a document generated at a given point in time reflects the data as it existed at that time and may be inaccurate now. When you update a document, B O reconnects to the database […]

Continue reading about How often is document data refreshed in BusinessObjects?

admin on June 4th, 2015

Ans: Security access levels are assigned to user profiles by the BusinessObjects Administrator using the Supervisor component of the B O tool. Security access can be table or object specific. This allows the B O Administrator to prohibit certain end users from viewing information of a sensitive or critical nature. Universes, and user’s rights to […]

Continue reading about How is the Data Warehouse security established?

admin on June 4th, 2015

The Data Mart is a database used for decision support, but organized for one department or function. Often the data mart contains summarized transaction data and is designed for fast query performance. In BusinessObjects, the data mart Universe is a business-oriented mapping of the data structure found in databases; tables, columns, joins, etc. and typically […]

Continue reading about What makes up a data mart Universe?

admin on June 4th, 2015

Ans. The objectives of Text Mining can be varied:To quantify a text or parts of a text to extract the meaning structures from them strongest, To establish bonds between the terms and the documents To analyze the documents in their associating qualitative and quantitative information structured To lay down rules of automatic classification of documents

Continue reading about Which are the objectives of Text Mining

Ans. Mining can use data from a data warehouse as well as data mart for the purpose of analysis where Data warehousing is the process of integrating enterprise-wide corporate data into a single repository but  “data mart” is a department or functional oriented data warehouse. It is a scaled down version of a data warehouse […]

Continue reading about Which are the principal differences between Data Mining and the statistical analysis from the data?

Ans. There are a lot of software companies and experts claiming to do “data mining” when in fact they are performing “data reporting.” Data mining starts with data integration ,cleansing and ends with predictions with their accuracy. In addition, ranks the predictive parameters and gives users how well they account for the observed variability. The […]

Continue reading about What is the major difference between data reporting and data mining ?

Ans.  OLAP is a technical concept where, most often, a reporting tool is configured to understand your database schema and composition (facts [values and attributes) and dimensions [levels and descriptors]). By simple point-n-clicking, a user can run any number of  user-designed reports without having to know anything of SQL or the schema.   But Data mining […]

Continue reading about What is the difference between OLAP and data mining

admin on April 27th, 2012

Designer Object Layout: The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links, expanding the icon border can significantly improve readability. This approach takes extra effort at first, so a pattern of work needs to be identified and adopted to help development. The […]

Continue reading about Designer Object Layout

admin on April 27th, 2012

Datastage Project_Plus Environment Variables: The Project_Plus directory structure is made to be transparent to the DataStage application, through the use of environment variable parameters used by the DataStage job developer. Environment variables are a critical portability tool that enables DataStage applications to be deployed through the life cycle without any code changes. In support of a Project_Plus […]

Continue reading about Datastage Project_Plus Environment Variables