Emp Table: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-95 800 20 7499 ASHA SALESMAN 7698 20-Feb-95 1600 300 30 7521 WASIM SALESMAN 7698 22-Feb-95 1250 500 30 7566 RAJA MANAGER 7839 02-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..
Question.1 What is Microstrategy Desktop? Answer: Microstrategy Desktop is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities. Question.2 What does Microstrategy Desktop allow users to do? Answer: Using Microstrategy Desktop, users can easily access and share critical corporate information they need to make cost-cutting decisions..
Question.1 What is single LTS and multiple LTS? Answer: The logical table created at the BMM layer can be based on the data from a single physical layer table, when it is called single Logical Table source. When the specific logical layer table is dependent on the columns of different..
Question.1 What would you do to remove Microsoft visual basic name space? Answer: .NET has many new features and application supportive tools. To remove Microsoft visual basic name space all you have to do is to 1) Remove the import manually every time you start the project. 2) Creating a..
Question.1 What are the two base classes a WebPart you are going to use within SharePoint 2007 can inherit from? Answer: There are two base classes that a WebPart which is going to be consumed by SharePoint can inherit from, either the SharePoint WebPart Base class or the ASP.NET 2.0..
Question.1 What is IIS? Why is it used? Answer: Internet Information Services (IIS) is created by Microsoft to provide Internet-based services to ASP.NET Web applications. It makes your computer to work as a Web server and provides the functionality to develop and deploy Web applications on the server. IIS handles..
Question.1 What are implementation inheritance and interface inheritance? Answer: Implementation inheritance is achieved when a class is derived from another class in such a way that it inherits all its members. Interface inheritance is when a class inherits only the signatures of the functions from another class. Question.2 What are..
Question.1 Explain about your SQL Server DBA Experience? Answer: This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in..
Question.1 What is ASP? Answer: Active Server Pages (ASP), also known as Classic ASP, is a Microsoft’s server-side technology, which helps in creating dynamic and user-friendly Web pages. It uses different scripting languages to create dynamic Web pages, which can be run on any type of browser. The Web pages..
Question.1 What is the difference between connected and unconnected transformation? Answer: Connected Transformation: Connected transformation is connected to other transformations or directly to target table in the mapping. Unconnected Transformation: An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns..