top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Incremental loading for fact table in informatica

+2 votes
326 views

I am performing SCD type 1 mapping. I have these source tables.

1.CUSTOMERS, (Source customer File)
2.PRODUCTS (Source Product File)
3.SALES   (source Sales file)

Also, these are dimensions and fact tables.

1.D_CUSTOMERS (SCD 1),
2.D_PRODUCTS (SCD 1) and
3.F_SALES_DLY (Fact)

Sales contains daily level data. Fact table will have sales & quantity data aggregated for product & for a month.(Fact table should be incremental for 24 months.(It should always contain 24 months of data)

I am bit confused, How to make fact table incremental? If i try to use any transformation(filter) to get last 24 months records, is it feasible solution?

Please suggest me something..

Thanks...

posted Sep 26, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

One way to implement it is split the task into two steps: (1) create a mapping that will delete transactions older than 24 months, (2) create a second mapping to get the transactions for the last 24 months from SALES, aggregate it and then insert the new values and update the existing ones.

answer Oct 6, 2014 by Shweta Singh
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...