Interested to Buy Any Domain ? << Click Here >> for more details...
What is facttable granularity?
- 2 Answers
- 8145 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri ram
The level of details to be stored in fact table is termed
as granularity.
Eg: for a Retail store, the granularity for sales fact is
as that of Point Of Sales i.e., each transaction occurs,
the data is stored in the fact table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
After you gather all the relevant information about the
subject area, the next step in the design process is to
determine the granularity of the fact table. To do this you
must decide what an individual low-level record in the fact
table should contain. The components that make up the
granularity of the fact table correspond directly with the
dimensions of the data model. Thus, when you define the
granularity of the fact table, you identify the dimensions
of the data model.
| Is This Answer Correct ? | 1 Yes | 0 No |
How will you update the first four rows and insert next four rows in a mapping?
In a sequential batch can u run the session if previous session fails?
What is meant by lookup transformation? Explain the types of lookup transformation?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
what are the difference between Informatica 7.1 and 8.1?
What is Session and Batches?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
What are the data movement modes in informatica?
difference between source based commit? and target based commit? which is better with respect to performance?
What are pre and post-session shell commands?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What is a passive transformation?
Teradata 
