Question.1 What is the difference between FastLoad and MultiLoad? Answer: FastLoad uses multiple sessions to quickly load large amount of data on empty table. MultiLoad is used for high-volume maintenance on tables and views. It works with non-empty tables also. Maximum 5 tables can be used in MultiLoad. Question.2 Which..
Question.1 What is SharePoint 2010? Answer: SharePoint was born out of a simple idea: “Sharing Documents”. Microsoft developed family of software products called “SharePoint”, to perform features like File Sharing, Collaboration, and Web Publishing. In simple terms, SharePoint acts as the single platform to share, communicate, store, and collaborate the..
Question.1 What is private mode? When does user switch to user mode? Answer: Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted. Question.2 What is osp$ mean?..
Question.1 What is the advantage of structures? How do you use them in the ABAP programs? Answer: GLOBAL EXISTANCE (these could be used by any other program without creating it again). Question:2 What does an extract statement do in the ABAP program? Answer: Once you have declared the possible record..
Question.1 Define repository in terms of OBIEE? Answer: Repository stores the Meta data information. The extension of the repository file is “.rpd”. With OBIEE Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business..
Question.1 What is Query parameter in SSRS? Answer: Query parameters is mentioned in the query of the datasources that are to be included into the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can..
Question.1 What is ERP? Answer: ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business..
Question.1 What is Data warehouse? Answer: According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”. Question.2 What are the types of data warehouses? Answer: There are three..
Question.1 What is the difference between DataStage and Informatica? Answer: DataStage support parallel processing which informatica doesn’t. Links are object in the DataStage ,in Informatica it’s a port to port connectivity .In Informatica, its easy to implement Slowly Changing Dimensions which is little bit complex in Data Stage. DataStage doesn’t..
Question.1 What is the Metrics application? Answer: The new IBM Connections Metrics application provides a comprehensive set of quantitative and qualitative metrics that help measure the business value of IBM Connections to your organization. IBM Connections uses IBM Cognos Business Intelligence to generate reports that users can view directly in..