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…
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: 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…
