Posted On: Mar 14, 2020
Informatica transformations are repository entities that can read, change or pass data to the defined target structures like tables, files, or any other structures required. Active transformations are those which alters the data rows and the number of input rows passed to them.
Aggregator, filter, joiner, normalizer, etc. are a few examples of active transformation in Informatica. An active transformation can perform any actions; change the number of rows that passes through the transformation, change the transaction boundary, change the row type attribute.
Never Miss an Articles from us.
There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema..
In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..
A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales..