how can we calculate fact table size?
- 1 Answers
- 5552 Views
- I also Faced
- E-Mail Answers
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
| Is This Answer Correct ? | 3 Yes | 2 No |
Explain direct and indirect flat file loading (source file type) - informatica
What are the scheduling options to run a sesion?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
can we override a native sql query within informatica? How do we do it?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
In a table, 4 person having same salary. How to get Third person record only?
What is Performance tuning in Informatica?
How do you load unique records into one target table and duplicate records into a different target table?
What are teh different tasks that can be created in workflow manager?
What is the difference between stop and abort in informatica
if i am having 10 records in source, i want 20 records in target...how will you do it
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Teradata 
