Informatica Tutorial – Part 8

ETL process using Informatica: So far we have explained about the source tables and how data need to be transformed before loading into target tables. In this section, we will see how this is implemented using Informatica. Quick Overview: Sources: National Stock Exchange (NSE) and...
Read More

Informatica Tutorial – Part 7

Target Table Layout: TARGET_DW_DB is an Oracle Data Warehouse database in KLXY Limited. Table STOCK_TRADING_FCT is mapped with the source tables NSE_TBL and BSE_TBL and linked with the LOOKUP tables. Data from NSE_TBL and BSE_TBL will be migrated to STOCK_TRADING_FCT on the last day of...
Read More

Informatica Tutorial – Part 6

Lookup Table 3: MONTH_LKP   Month Identifier MTH_ID Primay Key 1 2 3 4 5 6 7 8 9 10 11 12 Month Description MTH_DESC Standalone Column January February March April May June July August September October November December System Date SYS_DT Standalone Column 01-Jan-2007...
Read More

Informatica Tutorial – Part 5

Lookup Tables: Data from NSE_TBL and BSE_TBL are analyzed and the necessary lookup tables/fact tables are created. Here lookup tables include Source System Lookup, Company Lookup, Month Lookup, Date Lookup which are named SOURCE_SYSTEM_LKP, COMPANY_LKP, MONTH_LKP and DATE_LKP. The only fact table (i.e) Stock Trading...
Read More

Informatica Tutorial – Part 4

Table 2: BSE_TBL   Transaction Date TRNSCTN_DT Transaction_Date 23-Mar-07 24-Mar-07 25-Mar-07 23-Mar-07 24-Mar-07 25-Mar-07 23-Apr-07 24-Apr-07 25-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 Company Code CMPNY_CD Script_Code ABCCORP ABCCORP ABCCORP XYZPRIVATELIMITED XYZPRIVATELIMITED XYZPRIVATELIMITED ABCCORP ABCCORP ABCCORP XYZPRIVATELIMITED XYZPRIVATELIMITED XYZPRIVATELIMITED Previous Day Closing Price PRVS_DY_CLS_PRC Last_Day_Close 974 999.15 1024.15...
Read More

Scorecards

Scorecards are similar to Dashboards in a way that it provides easy-to-understand, summarized, at-a-glance data for the managers and top officials to tell them about their company’s present and past performance. Scorecards thus help to monitor the Key Performance Indicators accurately and to communicate the...
Read More

Dashboard Software

Following are few of the famous Business Intelligence Dashboard software available in the current market. Cognos ReportNet: A product from Cognos that helps to build, distribute, and view multi-object dashboards with graphical elements such as gauges, charts, and clickable pictures. Connects dashboards with underlying tabular...
Read More

Meta