There are various software development approaches defined and designed which are Used/employed during development process of software, these approaches are also Referred as “Software Development Process Models”. Each process model follows a Particular life cycle[…]
Category: Data Warehouse
How to Create Integration service in Informatica Admin?
Step1: First Login to Informatica power center admin Step2: Right Click on Domain and select power center Integration service, new window opens Step3: Here you have to provide integration service name, select license and[…]
Source Qualifier and Expression Transformation
Source Qualifier Transformation This is Active and Connected Transformation. The Source Qualifier transformation represents the rows that the Power Center Server reads when it runs a session. Source Qualifier Transformation is not reusable. This[…]
Informatica Interview top 50 Question with solution
Differences between Connected and Unconnected Lookup? The differences are illustrated in the below table Connected Lookup Unconnected Lookup Connected lookup participates in dataflow and receives input directly from the pipeline Unconnected lookup receives input values[…]
Basic Of SQL for SQL Server
DBMS : ( Database Management System): Data Base Management System is the management system or maintenance system on databases. (Or) It is a suite of software program for creating, maintaining & manipulating the data in[…]
Informatica PowerCenter Installation Guide : Step by Step
Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter helps in extraction of data from its source, transforming it as per[…]
Data warehouse Concepts
Business Intelligence: BI is a set of processes, tools, technologies and methodologies that combine data from various data sources and make the single source of data available at right time so that timely, better informed[…]