top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: Is fact a denormalized or a normalized table?

+2 votes
458 views
Informatica: Is fact a denormalized or a normalized table?
posted Apr 7, 2015 by Amit Sharma

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

1 Answer

0 votes

Fact tables are highly normalized.In dimensional modeling (Star and snowflake), fact tables are present in 3rd normalized form..

Flat table is always Normalised since no redundants!!

answer Apr 7, 2015 by Manikandan J
Similar Questions
+2 votes
Incremental loading for fact table in informatica

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...

0 votes
Updating or Inserting records into table using informatica

have two tables ACC and ACC_Restrict. I want to check the values of the column, P_R of either tables to see whether I should either insert, update or do nothing to ACC_Restrict. If the value is active in ACC but not in ACC_Restrict then insert into ACC_Restrict if it is still active in both ACC and ACC_Restrict then do nothing. If it is not active anymore in ACC but is still in ACC_Restrict then update ACC_Restrict by updating end_date to today's date. How can I achieve this in informatica?

Edit: There has been a modification of the requirement. ACC will only contain modifications to the account of someone. So if nothing has changed in someone's account we don't see anything in ACC but that doesn't mean if he had a restriction before, it has been lifted. It's just because nothing has changed so it doesn't appear in ACC. How do I manage this?

Note: P_R is a restriction on an account. I put the end_date to a date close to infinity and when the restriction is removed from the account I update ACC_Restrict by changing end_date to present date.

enter image description here
enter image description here

...