Home » Archive by category "ETL – Informatica"

Informatica Tutorial – Part 15

Workflow creation in Informatica (Workflow Manager): Once the mapping is created in the mapping designer, go to the “MAPPING” menu and select the option “VALIDATE”. Once the above is completed go ahead with the workflow creation. Open up workflow manager and create workflow using the...
Read More

Informatica Tutorial – Part 14

Each and every column in the target table (STOCK_TRADING_FCT), is derived from the existing source tables as follows. Column Name:¬†STCK_TRD_ID Loading Logic: After the source qualifier Use the ‘Sequence Generator’ Transformation. Set the Start value, interval and the end value in the properties of the...
Read More

Informatica Tutorial – Part 13

PARAMETER MAPPING: Parameter file is used to store variables that can be used anywhere within the repository and can be used by any other mappings in the same repository. Parameter file can be used to store dates, characters, strings, and numbers. Parameter file is created...
Read More

Informatica Tutorial – Part 12

Source Qualifier Transformation Continued… Source tab will contain the source table details. Metadata Extensions tab is to add any new column, but we will not be able to add any new column in the SQ but only using expression transformation. In this source qualifier, source...
Read More

Informatica Tutorial – Part 11

Implementing Extraction Mapping in Informatica (Mapping Designer): Open the mapping designer and select the Create Mapping. Give in the mapping name as m_Stockexchange as per the naming convention. From the navigator drag the source NSE. This source will be displayed along with the Source qualifier,...
Read More

Informatica Tutorial – Part 10

WAREHOUSE DESIGNER: We are having the target table STOCK_TRADING_FCT with 11 columns. Target definitions could be done by the following ways, Importing the similar target definition. Creating the target definition. Using the existing source definitions for the target. Importing the target definitions, in the warehouse...
Read More

Informatica Tutorial – Part 9

To import an excel source definition, follow these steps: Step I: Microsoft Excel ODBC driver should be installed in the system. Step II: Create a Microsoft Excel ODBC data source for each source in the 32 Bit ODBC Administrator. Step III: Prepare MS excel spreadsheet...
Read More