GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 248 of 312    Print  
How can we calculate the fact table size?

  
Total Answers and Comments: 2 Last Update: June 17, 2008     Asked by: sridhar.gonda 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 12, 2007 00:26:13   #1  
suvashis Member Since: August 2007   Contribution: 4    

RE: How can we calculate the fact table size?
hi

fact table size: it depends upon dimension table size

 
Is this answer useful? Yes | No
June 17, 2008 14:56:15   #2  
nandu214 Member Since: June 2008   Contribution: 5    

RE: How can we calculate the fact table size?
Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.

Ex:- if we have 100 customers and 200 products for 5 years of data for this the fact table size is

(5*365)*100*200 this is the fact table size

Note: here consider 365 days for a year 

Hope this may helps

if u cant clear mail me

 
Is this answer useful? Yes | No

 Related Questions

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ...

Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita.
Read Answers (3) | Asked by : Arpita

Latest Answer : CREATE OR REPLACE  PROCEDURE TIMEDIMBUILD   (p_start_date IN DATE,  p_end_date IN DATE)AS  v_full_date DATE;  v_day_of_month NUMBER; v_day_of_year NUMBER;  v_day_full_name VARCHAR2(30); v_week_number  ...

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Read Answers (5) | Asked by : kishore

I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Read Answers (1) | Asked by : Adi
Tags : Metadata

Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan
Read Answers (4) | Asked by : Kamalnayan Maramraj
Tags : RDBMS

Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful?
Read Answers (3) | Asked by : sree

Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq.
Read Answers (1) | Asked by : mayur

I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance
Read Answers (1) | Asked by : mhnoor


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 

Table space - Important concept of Database

Table space Important concept of Database Wondering what a Table space is Database is divided into one or more logical storage units known as table space The table space is created by database administrator After the table space gets created by administrator tables can be created by users in their
 

WebSphere V5.0 : Defining a table

WebSphere V5 0 Defining a table In this tutorial you will learn about WebSphere V5 0 Defining a table Steps to define a table in your database mosgoogle Tables are logical structures maintained by the database manager Tables are made up of columns and rows You can define tables as part of your data
 

Oracle Apps Table Registration API

Oracle Apps 11i Free Training Table Registration API This chapter provides you with information you need to register tables to be used in Oracle Alerts and Flexfields with Oracle Applications We will be learning about Procedures in the AD DD Package Procedure REGISTER TABLE Procedure REGISTER COLUMN
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape