what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 7400 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
A Fact table is a table that contains the measures of
intersert.
A dimensional table is a collection of hierarchies and
categories along which the user can drill down and drill
up. it contains only the textual attributes.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is the difference between orabulk and bcp stages?
Can you explain tagbatch restructure operator?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
If you want to use a same piece of code in different jobs, how will you achieve this?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to manage date conversion in Datastage?
What are routines in datastage? Enlist various types of routines.
What are the functionalities of link collector?
How can we improve the performance in datastage?
To see hidden files in LINIX?
How you can fix the truncated data error in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
what is the difference between == and eq in UNIX shell scripting?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain how a source file is populated?
