DW & ETL

ETL Tool – Informatica – Part 2

Power Exchange: Informatica Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by…

9 years ago

ETL Tool – Informatica – Part 1

Informatica: Informatica is a powerful ETL tool from Informatica Corporation, a leading provider of enterprise data integration software and ETL…

9 years ago

Informatica Transformations – Part 5

XML Source Qualifier Transformation: XML Source Qualifier is a Passive and Connected transformation. XML Source Qualifier is used only with…

9 years ago

Informatica Transformations – Part 4

Sequence Generator Transformation: Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key…

9 years ago

Informatica Transformations – Part 3

Lookup Transformation: Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to…

9 years ago

Informatica Transformations – Part 2

Aggregator Transformation: Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages…

9 years ago

Informatica Transformations – Part 1

What are Informatica Transformations? [Submitted by: Radhika, Michigan, US.] In Informatica, Transformations help to transform the source data according to the…

9 years ago

Informatica ETL Interview Questions and Answers – Part 3

Informatica Interview Questions & Answers: P. How DTM buffer size and buffer block size are related? The number of buffer blocks…

9 years ago

Informatica ETL Interview Questions and Answers – Part 2

Informatica Interview Questions & Answers: H. How to join 2 tables, without using any condition? It is not possible to…

9 years ago

Informatica ETL Interview Questions and Answers – Part 1

Informatica Interview Questions & Answers: A. What are the differences between Connected and Unconnected lookup? Connected lookup participates in the…

9 years ago