#informatica interview question

Informatica Sorter Transformation properties in details

Informatica Sorter Transformation properties. Last time, we started with introduction of sorter transformation in informatica. We covered basic of Informatica Sorter Transformation properties. We also saw how to add sorter transformation in informatica. We checked why sorter transformation is active Transformation. In this article, we will go through Informatica Sorter Transformation propertiesin…

Steps to add Sequence generator in informatica mapping

How to add Sequence generator in informatica mapping. 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 other informatica tutorial, we discussed about Sequence Generator Transformation propertiesin…

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…

Sequence Generator Transformation in Informatica

Sequence Generator Transformation in Informatica, is a Passive and connected transformation which let you generate numeric sequence unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers. In below article we will go through the details of Sequence generator transformation in Informatica.

Use of Sequence Generator Transformation in Informatica

The…

update without update strategy in informatica

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? Lets go through below article ,…

Memory allocation for lookup caches in partitioned session

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.

  Memory allocation for lookup caches

How Java Transformation works in Informatica ?

How Java Transformation works in Informatica : Java transformation was added in Informatica powercenter 8.0 version. With introduction of Java transformation, Informatica provided a simple native programming interface to define transformation functionality with the Java programming language. We can use the Java transformation to quickly define simple or moderately complex transformation…

Difference between filter and Router Transformation

Difference between filter and Router Transformation : We talked about filter transformation  and router transformation in Informatica in details. We checked the scenarios where to add those transformation  and how to add them. Here we will about difference between  filter and  router transformation in Informatica or in other word difference between router and filter transformation in Informatica.