Tanubhrt.This.Side

TheTechWorld

  • Lead And Lag Analytic Functions

    Analytic functions are also called the windowing functions and have been introduced in Oracle 8i. These functions, unlike the aggregate functions, do not reduce the number of rows returned, however, just like aggregate functions they also operate on a set of rows. This time we are looking at two of the analytics functions – LEAD Continue reading

    ,

  • Dealing With Data Types In Informatica

    You have to deal with data types all the time in Informatica. There will be lot of conversions and you have to deal with it. A common error that people do is with ‘Mobile Number’. Now, most often, the mobile number column is given in string and you need to perform some operations on it Continue reading

    ,

  • Indirect File Type in Informatica

    Informatica allows you to bring together data from different sources into one table and there are two ways of doing it. 1. Direct Way — In this way you simply import all the required sources in the source analyzer and do the Union Transformation. The result of the Union Transformation are then uploaded in the Continue reading

  • Inserting ID in the Target Table

    When creating mapping, there are times when you need to generate the ID for every record. In cases like these, you need to make use of sequence transformation. This transformation allows you to automatically generate a number for the rows in the table. To be able to use this transformation you need to click on Continue reading

  • Tracing Level in Informatica

    Tracing level in Informatica tells the level of detail about the transformation that the Integration Service writes into the session log. There are four types of tracing levels in Informatica Sequence Transformation – Terse – This level of tracing logs initialization information, error messages and notification of rejected data in the session log file. Normal Continue reading