top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How will you find weather dimension table is big in size of a fact table?

+1 vote
331 views
How will you find weather dimension table is big in size of a fact table?
posted Oct 13, 2015 by Amit Sharma

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

1 Answer

0 votes

if You have told, you can find the tool option tab under that ESTIMATE TABLE SIZE option,in that u can define the table
name and schema name ,in that way u can find which table is big in size

answer Oct 13, 2015 by Manikandan J
Similar Questions
+2 votes

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

...