Question.1 What are the advantages of column-based tables? Answer: Advantages: Faster Data Access: Only affected columns have to be read during the selection process of a query. Any of the columns can serve as an index. Better Compression: Columnar data storage allows highly efficient compression because the majority of the..
Question.1 What is the performance on SAP HANA One as compared to SAP HANA on-premise? Answer: For a similar number and type of CPU cores, memory and I/O configuration, SAP HANA One is comparable to SAP HANA on-premise. Your actual performance will vary based on the nature of workload. Question.2..
Question.1 What is SAP HANA One? Answer: SAP HANA One is a single HANA instance hosted on Amazon Web Services. Customers and Partners can use SAP HANA One to provision a secured instance of SAP HANA database. This instance can be used to build and deploy on-demand applications that leverage..
Question.1 Can you use mapping without source qualifier? Answer: Not possible, If source RDEMS/DBMS/Flat file use SQ or use normalizer if the source cobol feed. Question 2.When do you use a normalizer? Answer: Normalized can be used in Relational to denormilize data. [sociallocker] Question.3 What are stored procedure transformations. Purpose..
Question.1 What are the different uses of a repository manager? Answer: Repository manager used to create repository which contains metadata the informatica uses to transform data to from source to target. And also it use to create informatica user’s and folders and copy, backup and restore tie repository . Question.2..
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 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 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..
Question.1 What is J2EE? Answer: J2EE is an environment for developing and deploying enterprise applications. The J2EE platform consists of a set of services, application programming interfaces (APIs), and protocols that provide the functionality for developing multi-tier, web-based applications. Question.2 What is the J2EE module? Answer: A J2EE module consists..
Question.1 What is the Java API? Answer: The Java API is a large collection of ready-made software components that provide many useful capabilities, such as graphical user interface (GUI) widgets. Question.2 Describe the principles of OOPS? Answer: There are three main principals of oops which are called Polymorphism, Inheritance and..