Tutorial corner

Informatica,ETL,oracle,sql/plsql

Informatica Interview Question

Informatica Interview Question

Fibonacci series in Informatica : Informatica Scenario question

Expression Transformation sign

Fibonacci series in Informatica :  Continuing with our series of informatica scenario based interview question , in this article we will see how to implement Fibonacci series in informatica . I believe you must have already designed this program in native language like C++ or Java . What is Fibonacci Series ? The Fibonacci sequence is […]

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

Aggregator Transformation in Informatica Without group by

Aggregator Transformation image

Aggregator Transformation in Informatica Without group by : Earlier, we learnt about the Aggregator transformation in Informatica , steps to create it , configuring the port and properties.  We also saw one Example of aggregator Transformation in Informatica mapping .In that example we marked DEPT port as group by port and all calculation was done on group of dept no. Here comes one […]

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

Example of XML Source in Informatica

xml

Example of XML Source in Informatica : Here, we will cover “How to load XML files in table using Informatica mapping“. We will first discuss the steps of defining XML source definition in Informatica , configuring mapping session properties . Lets try with a very simple but detailed example of XML Source in Informatica mapping. Check here for Load csv […]

Copyright 2015 - Tutorial Corner Frontier Theme