Tutorial corner

Informatica,ETL,oracle,sql/plsql

Lookup Transformation

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

Informatica Interview question lookup Transformation

Informatica Interview Question lookup Transformation

we have gone through the Informatica tutorial on Lookup Transformation in  Informatica. We have also gone through the example of Lookup Transformation in Informatica Mapping. Here we will go though some of the commonly asked Informatica Interview question lookup Transformation. Informatica Interview question lookup Transformation 1. What is Lookup Transformation ? Ans: Lookup Transformation in Informatica , is a connected/Unconnected and Passive /Active transformation  which let you […]

Difference between joiner and Lookup Transformation

Joiner Transformation vs lookup Transformation

Difference between joiner and Lookup Transformation : Earlier we talked about joiner  transformation  and lookup transformation in Informatica in details. We checked the scenarios where to use joiner and lookup transformation in informatica mapping. Here we will about difference between  joiner and lookup transformation in Informatica or in other word difference between lookup and joiner transformation in Informatica.This is commonly asked Informatica interview question as well. Check here […]

Informatica Performance Tuning Tips Lookup Transformation

Lookup Transformation in Informatica

Informatica Performance Tuning Tips Lookup Transformation. Earlier we talked about Lookup transformation in Informatica with lookup transformation example. We also checked how we can improve the performance by enabling lookup transformation cache. Here we will talk about Informatica Performance Tuning Tips  for Lookup Transformation. Check here for Informatica expression transformation performance tuning Informatica Performance Tuning Tips Lookup Using Cache for Lookup Transformation : […]

Difference between Static Cache and Dynamic Cache in Informatica

Lookup Transformation in Informatica

Last time, we discussed about the different type of cache lookup in Informatica. We discussed about Static Cache and Dynamic Cache in Informatica. In below article we discuss the differences between Static Cache and Dynamic Cache in Informatica lookup in some more details. Check here for Types of lookup cache in informatica Static Cache and Dynamic […]

Copyright 2015 - Tutorial Corner Frontier Theme