• Home »

Question.1  What are the components of Informatica? And what is the purpose of each? Answer:   Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the trig jered..

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 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  Which TCP/IP port does SQL Server run on? How can it be changed? Answer:  SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties. Question.2   What are the difference between clustered and a non-clustered index? Answer:  A clustered index is a special type..

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

Qustion.1   Explain Qlikview architecture? Answer:  QlikView deployments have three main infrastructure components: 1.QlikView Developer :  Is a Windows-based desktop tool that is used by designers and developers to create a) a data extract and transformation model and b) to create the  graphical user interface (or presentation layer). 2.QlikView Server (QVS)..