Informatica: Informatica is a powerful ETL tool from Informatica Corporation, a leading provider of enterprise data integration software and ETL software. The important Informatica Components are: Power Exchange Power Center Power Center Connect Power Exchange Power Channel Metadata Exchange Power Analyzer Super Glue In Informatica, all the Metadata information about source systems, target systems and…
Informatica Interview Questions & Answers: P. How DTM buffer size and buffer block size are related? The number of buffer blocks in a session = DTM Buffer Size / Buffer Block Size. Default settings create enough buffer blocks for 83 sources and targets. If the session contains more than 83, you might need to increase DTM…
Informatica Interview Questions & Answers: A. What are the differences between Connected and Unconnected lookup? Connected lookup participates in the mapping(dataflow), just like any other transformation. Unconnected lookup is used when a lookup function is used instead in an expression transformation in the mapping in which case the lookup does not appear in the main…
ETL Concepts: Extraction, transformation, and loading. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database. The first step in ETL process is mapping the data between source systems and target database(data warehouse or data mart). The second step is cleansing of source data in staging area….
Database – RDBMS: There are a number of relational databases to store data. A relational database contains normalized data stored in tables. Tables contain records and columns. RDBMS makes it easy to work with individual records. Each row contains a unique instance of data for the categories defined by the columns. RDBMS are used in…
What is a Data Warehouse? According to Inmon, famous author for several data warehouse books, “A data warehouse is a subject oriented, integrated, time variant, non volatile collection of data in support of management’s decision making process”. In order to store data, over the years, many application designers in each branch have made their individual decisions…
