real time complex mappings or complex transformations in Informatica.

Most complex logic we use is denormalization.

We dont have any Denormalizer transformation in INformatica.

So we will have to use an aggregator followed by an expression.

Apart from this, we use most of the complexity in expression transformation involving lot of nested IIF's and Decode statements...another one is the union tranformation and joiner.