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..