Tutorial corner

Informatica,ETL,oracle,sql/plsql

Informatica Transformation

Informatica Transformation

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

How to remove null records in informatica ?

Filter Transformation in informatica

While developing informatica mapping , you come across various informatica scenarios where you need to skip null records while loading data. In other words you want to remove null records in informatica . First transformation comes to your mind will be filter transformation . But you may not be sure how to use filter transformation to […]

How Java Transformation works in Informatica ?

Java Transformation 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 functionality without advanced knowledge of […]

Difference between filter and Router Transformation

filter transformation vs 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. This is commonly asked Informatica interview question as well. Check […]

Example of Rank transformation in informatica

Rank Transformation in Informatica

Earlier we talked about Rank transformation in Informatica , steps to create it . We also discussed the business scenario of Rank Transformation in Informatica. In below article we will go through a working  Example of Rank transformation in informatica mapping . Example of Rank transformation in informatica Create a mapping to load the target table with top 2 income  (employees) in each department with […]

Copyright 2015 - Tutorial Corner Frontier Theme