Tutorial corner

Informatica,ETL,oracle,sql/plsql

Expression Transformation

Replacing NULL Value with prev col value in informatica

Informatica scenarios

Expression transformation scenarios : We will be ending this weekend with another illustrative informatica scenario based question. We will see how to use expression transformation in informatica to solve complex scenarios we faced in our work. We just need to play with expression of each port and it will be surely help in building your informatica […]

How to convert rows to columns in Informatica

Aggregator Transformation image

Last time we discussed , how to convert columns to rows in informatica(or in other word Transpose columns to rows) with the help of Normalizer Transformation in Informatica. Now we will  discuss just opposite to it. In below article , we will see step by step example to convert rows to column in Informatica with the […]

Informatica Performance Tuning Tips Expression

Expression Transformation sign

Informatica Performance Tuning Tips Expression . Earlier,we talked about the Expression transformation in Informatica with example. We discussed about the steps to add expression transformation, configuring the ports and properties of  it. We also saw how different types of port (input,output , variable) are created and used in Expression Transformation. Here we will talk about Informatica […]

How to use expression transformation in informatica

Expression Transformation sign

In the last article , we learn about the Expression transformation in Informatica , steps to create it , configuring the port. We also discussed the various properties of Expression Transformation. Here we will discuss How to use expression transformation in informatica mapping with example How to use expression transformation in informatica Create a mapping to populate Target […]

Expression Transformation in Informatica with Example

Expression Transformation sign

Expression Transformation in Informatica , is a connected passive transformation (number of input and output rows is the same), which let you modify individual ports of a single row , or add or suppress them. It helps implement the complicated data transforms, applies business logic and performs checks and validations.For example: calculating annual Salary, concatenation. In below article […]

Copyright 2015 - Tutorial Corner Frontier Theme