Explore topic-wise InterviewSolutions in Current Affairs.

The MANAGER is a GRAPHICAL tool that ENABLES you to view and manage the contents of the DataStage REPOSITORY.

The Manager is a graphical tool that enables you to view and manage the contents of the DataStage Repository.

DATASTAGE DIRECTOR is USED to run the jobs and validate the jobs. we can GO to datastage director from datastage designer it self.

datastage director is used to run the jobs and validate the jobs. we can go to datastage director from datastage designer it self.

The Administrator enables you to set up DataStage users, CONTROL the purging of the REPOSITORY, and, if National Language SUPPORT (NLS) is enabled, install and manage maps and locales.

The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales.

You use the Designer to build jobs by creating a visual design that models the FLOW and TRANSFORMATION of data from the data source through to the target WAREHOUSE. The Designer GRAPHICAL interface lets you select stage icons, drop them onto the Designer work AREA, and add links.

You use the Designer to build jobs by creating a visual design that models the flow and transformation of data from the data source through to the target warehouse. The Designer graphical interface lets you select stage icons, drop them onto the Designer work area, and add links.

Either use COPY command as a Before-job subroutine if the METADATA of the 2 files are same or create a job to concatenate the 2 files into ONE if the metadata is DIFFERENT.

Either use Copy command as a Before-job subroutine if the metadata of the 2 files are same or create a job to concatenate the 2 files into one if the metadata is different.

Oracle 8i does not SUPPORT PSEUDO column sysdate but 9i SUPPORTS
Oracle 8i we can create 256 COLUMNS in a table but in 9i we can upto 1000 columns(fields).

Oracle 8i does not support pseudo column sysdate but 9i supports
Oracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields).

Qulaity Stage can be integrated with DataStage, In Quality Stage we have MANY stages like INVESTIGATE, match, SURVIVORSHIP like that so that we can do the Quality related works and we can INTEGRATE with datastage we need Quality stage plugin to ACHIEVE the task.

Qulaity Stage can be integrated with DataStage, In Quality Stage we have many stages like investigate, match, survivorship like that so that we can do the Quality related works and we can integrate with datastage we need Quality stage plugin to achieve the task.

MetaStage is used to HANDLE the METADATA which will be very USEFUL for data lineage and data ANALYSIS later on. Meta Data defines the type of data we are handling. This Data Definitions are stored in repository and can be ACCESSED with the use of MetaStage.

MetaStage is used to handle the Metadata which will be very useful for data lineage and data analysis later on. Meta Data defines the type of data we are handling. This Data Definitions are stored in repository and can be accessed with the use of MetaStage.

USING DB2 ODBC DRIVERS.

Using DB2 ODBC drivers.

IConv() - CONVERTS a string to an INTERNAL STORAGE FORMAT
OConv() - Converts an EXPRESSION to an output format.

IConv() - Converts a string to an internal storage format
OConv() - Converts an expression to an output format.

Routines are stored in the Routines branch of the DataStage REPOSITORY, where you can create, view or EDIT. The following are DIFFERENT types of routines:
1) Transform functions
2) Before-after job subroutines
3) Job Control routines.

Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines:
1) Transform functions
2) Before-after job subroutines
3) Job Control routines.

Link PARTITIONER - USED for partitioning the data.
Link Collector - Used for COLLECTING the PARTITIONED data.

Link Partitioner - Used for partitioning the data.
Link Collector - Used for collecting the partitioned data.

Typically a Reject-LINK is defined and the rejected data is loaded back into data warehouse. So Reject link has to be defined every Output link you wish to collect rejected data. Rejected data is typically bad data like duplicates of PRIMARY KEYS or null-rows where data is expected.

Typically a Reject-link is defined and the rejected data is loaded back into data warehouse. So Reject link has to be defined every Output link you wish to collect rejected data. Rejected data is typically bad data like duplicates of Primary keys or null-rows where data is expected.

PEOPLE do not have time to search through information to identify information that REQUIRES immediate action. An intelligent ALERTING system understands and constantly monitors the information users need, and DELIVERS information only when users need it. Users save time and take action when required.

People do not have time to search through information to identify information that requires immediate action. An intelligent alerting system understands and constantly monitors the information users need, and delivers information only when users need it. Users save time and take action when required.

Customers USE Microstrategy Narrowcast Server to deliver inventory alerts, business performance alerts, supply chain alerts, customer ACTIVITY alerts, stock and PERSONAL FINANCE alerts, last minute travel alerts, data load alerts, customer account activity alerts, and fraud alerts. New uses are constantly being developed for intelligent ALERTING.

Customers use Microstrategy Narrowcast Server to deliver inventory alerts, business performance alerts, supply chain alerts, customer activity alerts, stock and personal finance alerts, last minute travel alerts, data load alerts, customer account activity alerts, and fraud alerts. New uses are constantly being developed for intelligent alerting.

Through an easy-to-use SUBSCRIPTION WEB page, users specify what information they want. Some personalization OPTIONS include the language choices and specific information criteria such as certain products. Using this USER profile, Microstrategy Narrowcast Server SENDS only the information that the user has requested.

Through an easy-to-use subscription web page, users specify what information they want. Some personalization options include the language choices and specific information criteria such as certain products. Using this user profile, Microstrategy Narrowcast Server sends only the information that the user has requested.

Yes, users can SWITCH on and off their own information delivery. Administrators can also set up some ‘non-optional’ information delivery so that everyone RECEIVES the information. As a RESULT, users can obtain information without having to WAIT for IT to develop the REPORTS.

Yes, users can switch on and off their own information delivery. Administrators can also set up some ‘non-optional’ information delivery so that everyone receives the information. As a result, users can obtain information without having to wait for IT to develop the reports.

Users can RECEIVE both TABLES and charts from the MICROSTRATEGY platform, and content from current information sources such as transaction PROCESSING systems, Enterprise Resource Planning systems, databases, XML files, and web servers.

Users can receive both tables and charts from the Microstrategy platform, and content from current information sources such as transaction processing systems, Enterprise Resource Planning systems, databases, XML files, and web servers.

Information can be formatted into HTML, plain text, Microsoft Excel, or PDF files. The size and display of these files are adjusted to suit the email TYPE or the wireless DEVICE for DIFFERENT users.

Information can be formatted into HTML, plain text, Microsoft Excel, or PDF files. The size and display of these files are adjusted to suit the email type or the wireless device for different users.

Narrowcast Server can DELIVER information to email, mobile phones, PAGERS, faxes, PDAs, intranet and extranet WEB portals. Businesses can also BUILD and PLUG in their own Information Transmission Module to support their own devices.

Narrowcast Server can deliver information to email, mobile phones, pagers, faxes, PDAs, intranet and extranet web portals. Businesses can also build and plug in their own Information Transmission Module to support their own devices.

Microstrategy Narrowcast Server's world-class clustering and fail-over ENSURES support for mission-critical 24x7 systems. Rigorous in-house TESTING has proven that Narrowcast Server can personalize and deliver millions of MESSAGES a day. The SYSTEM tracks fail-over down to each message.

Microstrategy Narrowcast Server's world-class clustering and fail-over ensures support for mission-critical 24x7 systems. Rigorous in-house testing has proven that Narrowcast Server can personalize and deliver millions of messages a day. The system tracks fail-over down to each message.

Microstrategy DESKTOP is available in ENGLISH, French, German, Spanish, Korean, Italian, SWEDISH, JAPANESE and Portuguese.

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

Minimum requirements are a COMPUTER with at LEAST a 450MHZ PENTIUM- compatible CPU, 256MB of RAM and 500MB of hard disk.

Minimum requirements are a computer with at least a 450MHZ Pentium- compatible CPU, 256MB of RAM and 500MB of hard disk.

Microstrategy DESKTOP has more than 10 different subtotaling functions that aid analysis of the DATA. SUBTOTALS can be presented at any LEVEL in the rows, columns and pages on the REPORT.

Microstrategy Desktop has more than 10 different subtotaling functions that aid analysis of the data. Subtotals can be presented at any level in the rows, columns and pages on the report.

Microstrategy DESKTOP offers advanced printing CAPABILITIES. Features include REPEATING row /column headers, customizable headers and footers, and a comprehensive page setup menu. Users can preview reports before SENDING it to the printer.

Microstrategy Desktop offers advanced printing capabilities. Features include repeating row /column headers, customizable headers and footers, and a comprehensive page setup menu. Users can preview reports before sending it to the printer.

Yes, USERS can easily combine TABLES, images, graphs and other information onto the same page in a document. Visually IMPRESSIVE and compelling documents can be printed out and SHARED with corporate executives. Business users can now rearrange the organization of any report with simple drag and drop actions or by clicking on the new TOOLBAR icons to get entirely new views of the data, all from the same report and without requiring assistance from IT.

Yes, users can easily combine tables, images, graphs and other information onto the same page in a document. Visually impressive and compelling documents can be printed out and shared with corporate executives. Business users can now rearrange the organization of any report with simple drag and drop actions or by clicking on the new toolbar icons to get entirely new views of the data, all from the same report and without requiring assistance from IT.

Yes. Users can format their data into appealing reports using various formatting STYLES and graphs for maximum VISUAL impact. Users can choose from more than 30 different charting options to present information in the best LAYOUT POSSIBLE.

Yes. Users can format their data into appealing reports using various formatting styles and graphs for maximum visual impact. Users can choose from more than 30 different charting options to present information in the best layout possible.

MICROSTRATEGY Desktop preserves the look and feel of popular desktop software such as MICROSOFT Windows Explorer and Microsoft OFFICE. As such, users are immediately comfortable with Microstrategy Desktop. A CUSTOMIZED interface using HTML can be created, simplifying navigation and report EXECUTION.

Microstrategy Desktop preserves the look and feel of popular desktop software such as Microsoft Windows Explorer and Microsoft Office. As such, users are immediately comfortable with Microstrategy Desktop. A customized interface using HTML can be created, simplifying navigation and report execution.

Microstrategy Desktop provides INSTANT ACCESS and analysis of information. This high performance is enabled through INTELLIGENCE Cubes, caches, INCREMENTAL FETCHES and advanced analytic features.

Microstrategy Desktop provides instant access and analysis of information. This high performance is enabled through Intelligence Cubes, caches, incremental fetches and advanced analytic features.

Yes. Microstrategy Desktop USERS can USE a new Operational SQL Engine to include DATA from any operational system using completely free-form SQL, including STORED procedures and views.

Yes. Microstrategy Desktop users can use a new Operational SQL Engine to include data from any operational system using completely free-form SQL, including stored procedures and views.

Yes. With the release of MICROSTRATEGY 8, Microstrategy Desktop incorporates a new DYNAMIC DATA access engine designed to access multi-dimensional databases (MDDBs or OLAP Cube Databases) such as those from SAP Business INFORMATION Warehouse (BW) databases.

Yes. With the release of Microstrategy 8, Microstrategy Desktop incorporates a new dynamic data access engine designed to access multi-dimensional databases (MDDBs or OLAP Cube Databases) such as those from SAP Business Information Warehouse (BW) databases.

Yes. Reports created using Microstrategy Desktop are IMMEDIATELY AVAILABLE to other Microstrategy PRODUCTS because of our centralized metadata architecture.

Yes. Reports created using Microstrategy Desktop are immediately available to other Microstrategy products because of our centralized metadata architecture.

Users can obtain critical information immediately without waiting for IT DEPARTMENTS to create reports. The SOFTWARE is easy to use and provides CONTEXT SENSITIVE help, THUS eliminating the need for extensive support and maintenance staff.

Users can obtain critical information immediately without waiting for IT departments to create reports. The software is easy to use and provides context sensitive help, thus eliminating the need for extensive support and maintenance staff.

Users can analyze the information using STANDARD aggregations and more sophisticated functions such as average, summation, percentage contribution, standard DEVIATION and net present value. Investigative reporting, using pivoting, sorting, slicing, and drilling to more DETAIL, can be performed with simple mouse clicks. Users can also format reports to their specifications and view the data as intuitive charts and GRAPHS to identify TRENDS and anomalies quickly.

Users can analyze the information using standard aggregations and more sophisticated functions such as average, summation, percentage contribution, standard deviation and net present value. Investigative reporting, using pivoting, sorting, slicing, and drilling to more detail, can be performed with simple mouse clicks. Users can also format reports to their specifications and view the data as intuitive charts and graphs to identify trends and anomalies quickly.

Using Microstrategy Desktop, users can easily access and share critical corporate information they NEED to MAKE cost-cutting decisions and improve business processes. The information found in databases can also be used to help increase REVENUE and boost PROFITS. Users can access this database and SAP data WITHOUT having to learn technical database query (SQL) or multi-dimensional expression (MDX) syntax.

Using Microstrategy Desktop, users can easily access and share critical corporate information they need to make cost-cutting decisions and improve business processes. The information found in databases can also be used to help increase revenue and boost profits. Users can access this database and SAP data without having to learn technical database query (SQL) or multi-dimensional expression (MDX) syntax.

MICROSTRATEGY Desktop is a Windows client-server software application that provides INTEGRATED MONITORING, reporting, and ANALYSIS capabilities.

Microstrategy Desktop is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities.

Intelligent Cubes are USER or ADMINISTRATOR CREATED multi-dimensional cubes that operate within Microstrategy Intelligence Server. On Microstrategy's BI platform, creating an Intelligent Cube is as easy as creating a report. Intelligent Cubes enable Microstrategy to combine the speed and interactivity of multi-dimensional OLAP analysis and the analytical power and depth of relational OLAP.

Intelligent Cubes are user or administrator created multi-dimensional cubes that operate within Microstrategy Intelligence Server. On Microstrategy's BI platform, creating an Intelligent Cube is as easy as creating a report. Intelligent Cubes enable Microstrategy to combine the speed and interactivity of multi-dimensional OLAP analysis and the analytical power and depth of relational OLAP.

Microstrategy OLAP Services is an extension to Microstrategy Intelligence SERVER that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. With OLAP Services end users can add or remove report objects, add derived METRICS and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. OLAP Services enables FULL multi-dimensional OLAP analysis within Intelligent Cubes, while retaining users' ABILITY to seamlessly drill through to the full breadth and depth of the data WAREHOUSE.

Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. OLAP Services enables full multi-dimensional OLAP analysis within Intelligent Cubes, while retaining users' ability to seamlessly drill through to the full breadth and depth of the data warehouse.

Reports can be ATTACHED to time-based or event-based schedules that are defined by the administrator. These schedules automatically trigger the REPORT execution and place a NOTIFICATION message in the HISTORY FOLDER on completion.

Reports can be attached to time-based or event-based schedules that are defined by the administrator. These schedules automatically trigger the report execution and place a notification message in the History folder on completion.

Microstrategy Desktop can execute MULTIPLE reports SIMULTANEOUSLY. REPORT results are SAVED in a personal History folder when ready.

Microstrategy Desktop can execute multiple reports simultaneously. Report results are saved in a personal History folder when ready.

You can ACCESS data in all the MAJOR databases including Oracle, IBM DB2, Informix, NCR TERADATA, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL.

You can access data in all the major databases including Oracle, IBM DB2, Informix, NCR Teradata, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL.

You can export information from Microstrategy DESKTOP to TEXT files, Microsoft WORD, Microsoft Excel, Microsoft Access and HTML files. The formatting of the tables and data are preserved when you export to these FILE formats.

You can export information from Microstrategy Desktop to text files, Microsoft Word, Microsoft Excel, Microsoft Access and HTML files. The formatting of the tables and data are preserved when you export to these file formats.

Yes. Microstrategy 8 has EXTENDED its analytic engine with "DATA Mining Services" capability that allows reports and analyses to INCLUDE predictive capabilities in EVERY Microstrategy report or analysis. Microstrategy 8 includes the new ability to import data mining models directly from best-of-breed data mining products from vendors like IBM, Teradata, SAS, and SPSS using the new PMML or predictive modeling mark-up language standard.

Yes. Microstrategy 8 has extended its analytic engine with "Data Mining Services" capability that allows reports and analyses to include predictive capabilities in every Microstrategy report or analysis. Microstrategy 8 includes the new ability to import data mining models directly from best-of-breed data mining products from vendors like IBM, Teradata, SAS, and SPSS using the new PMML or predictive modeling mark-up language standard.

Yes. MICROSTRATEGY 8 can calculate FOUR of the primary DATA MINING functions including neural network algorithms, CLUSTERING algorithms, regression algorithms, and tree algorithms.

Yes. Microstrategy 8 can calculate four of the primary data mining functions including neural network algorithms, clustering algorithms, regression algorithms, and tree algorithms.

Yes. Microstrategy 8 extends the Microstrategy DATA modeling flexibility to include integrated views of data ACROSS heterogeneous data stores. By mapping conforming dimensions from different sources, Microstrategy Desktop can AUTOMATICALLY join data from multiple different sources in the same REPORT document. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data marts, SAP BW, and any NUMBER of operational system databases.

Yes. Microstrategy 8 extends the Microstrategy data modeling flexibility to include integrated views of data across heterogeneous data stores. By mapping conforming dimensions from different sources, Microstrategy Desktop can automatically join data from multiple different sources in the same report document. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data marts, SAP BW, and any number of operational system databases.

YES. Users can use Microstrategy DESKTOP to create REPORTS that access SAP data and join data ACROSS SAP BW Info CUBES and Query Cubes as well as access multiple instances of SAP BW at once.

Yes. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as well as access multiple instances of SAP BW at once.

Yes. This new Dynamic MDX Engine GENERATES OPTIMIZED MDX syntax that is fully CERTIFIED with SAP BW using SAP's HIGH performance BAPI interfaces.

Yes. This new Dynamic MDX Engine generates optimized MDX syntax that is fully certified with SAP BW using SAP's high performance BAPI interfaces.

Each Microstrategy DESKTOP user has a security profile defined by their ADMINISTRATOR. This profile controls access to application functionality, specific reports or particular data for individual users or groups of users. The Desktop interface will ADAPT and DISPLAY only what this user is ALLOWED to see.

Each Microstrategy Desktop user has a security profile defined by their administrator. This profile controls access to application functionality, specific reports or particular data for individual users or groups of users. The Desktop interface will adapt and display only what this user is allowed to see.

Microstrategy DESKTOP provides a host of security options to ENSURE that data is kept CONFIDENTIAL and private. To facilitate easy deployment and MINIMAL maintenance, Microstrategy Desktop integrates with WINDOWS NT and 2000 security and with Novell directory. As a result, users who have logged into these systems will not need to log on again.

Microstrategy Desktop provides a host of security options to ensure that data is kept confidential and private. To facilitate easy deployment and minimal maintenance, Microstrategy Desktop integrates with Windows NT and 2000 security and with Novell directory. As a result, users who have logged into these systems will not need to log on again.

Microstrategy Desktop is the intuitive client-server interface USED by business analysts and application DEVELOPERS. Microstrategy Desktop interacts with the Intelligence Server to BUILD metrics, create and format REPORTS, and retrieve TIMELY, accurate information to the desktop to enhance the decision-making process.

Microstrategy Desktop is the intuitive client-server interface used by business analysts and application developers. Microstrategy Desktop interacts with the Intelligence Server to build metrics, create and format reports, and retrieve timely, accurate information to the desktop to enhance the decision-making process.