Interested to Buy Any Domain ? << Click Here >> for more details...
What is facttable granularity?
- 2 Answers
- 8250 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 |
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What are the tasks that source qualifier perform?
What is data merging,data cleansing,sampling?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
how can we use sorter transformation in joins?
How to delete first 3 rows & last 3 rows in target table in informatica
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Diff b/w ShortCut and reusabel Object ?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Teradata 
