Question.1 What is the use of BusinessObjects Data Services? Answer: BusinessObjects Data Services provides a graphical interface that allows you to easily create jobs that extract data from heterogeneous sources, transform that data to meet the business requirements of your organization, and load the data into a single location. Question.2 ..
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 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..