Tutorial corner

Informatica,ETL,oracle,sql/plsql

Informatia scenarios

All informatica scenario based question , common informatica interview question

Example of XML Target in Informatica

xml

Example of XML Target in Informatica : In our last tutorial , we learnt about the XML file Source Definition in Informatica , steps to create via going through source analyzer tool, configuring the port and properties. In below tutorial , we will cover “How to create XML target in Informatica mapping“. We will first discuss the steps of defining XML Target  definition in […]

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

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

Split column to row in Informatica with Java Transformation

Java Transformation in Informatica

Last Time , we learnt how to convert columns to rows (or in other word Transpose columns to rows) with the help of Normalizer Transformation in Informatica. In another blog , we talked about converting multiple row to multiple column with the help of Aggregator Transformation in Informatica Mapping. In below article , we will see step by step example to […]

Copyright 2015 - Tutorial Corner Frontier Theme