Tutorial corner

Informatica,ETL,oracle,sql/plsql

Informatica Interview Question

Informatica Interview Question

Sequence Generator Transformation properties in informatica

Sequence generator transformation properties in informatica

Sequence Generator Transformation Properties. Last time, we started with introduction of sequence generator transformation in informatica. We discussed about use of sequence generator transformation in informatica. We also discussed about the available ports in informatica and their purpose. In this informatica tutorial, we will go through the Sequence Generator Transformation properties in informatica. How to set […]

update without update strategy in informatica

Update Strategy Transformation

Update without update strategy in informatica : Last time we went through update strategy transformation in informatica with example. Update Strategy transformation let you insert, update , delete data on target side . It can also reject the incoming data depending upon your condition . But one question arise , can we update without update strategy in informatica ? […]

Informatica PowerCenter Integration Service Architecture

Informatica Integeration Service

Informatica Integration Service . While discussing Informatica Architecture , we also went through various informatica services involved .Out of them most important one is Informatica Integration Service . Informatica Integration Service  is created while installing the Power Centre on the server.After creation of Integration service we use Administration console to mange the Integration Services. In below article […]

Memory allocation for lookup caches in partitioned session

Dynamic Cache Lookup in informatica

Lookup transformation is the most commonly used transformation in informatica . Earlier we discussed how we can increase the performance of lookup Transformation in informatica. We also discussed various Type of lookup Cache in informatica . In below article we will see how Memory allocation for lookup caches is done by informatica during partitioned session.   […]

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 […]

Copyright 2015 - Tutorial Corner Frontier Theme