Power Exchange: Informatica Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs. Power Exchange supports batch, real time and changed data capture options in main frame (DB2, VSAM, IMS etc.), mid range (AS400 DB2 etc.,), and for relational databases (oracle,…
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…
XML Source Qualifier Transformation: XML Source Qualifier is a Passive and Connected transformation. XML Source Qualifier is used only with an XML source definition. It represents the data elements that the Informatica Server reads when it executes a session with XML sources. Advanced External Procedure Transformation: Advanced External Procedure transformation is an Active and Connected…
Sequence Generator Transformation: Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers or to replace missing keys. It has two output ports to connect transformations. By default it has two fields CURRVAL and NEXTVAL(You cannot add ports to…
Lookup Transformation: Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables. For example, if we want to retrieve all the sales of a product…
Aggregator Transformation: Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups). For example, to calculate total of daily sales or to calculate average of monthly or yearly sales. Aggregate functions such as AVG, FIRST, COUNT,…
What are Informatica Transformations? [Submitted by: Radhika, Michigan, US.] In Informatica, Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target. Transformations are of two types: Active and Passive. Active Transformation: An active transformation can change the number of rows…
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: H. How to join 2 tables, without using any condition? It is not possible to actually possible to join two tables without using any condition. If we would like to join two tables, then in source qualifier transformation add all the ports from two tables(if both tables are from same…
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…
