Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8750 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 use of surogate key in datastage
Can you implement SCD2 using join, transformer and funnel stage?
How do y read Sequential file from job control?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to Remove Duplicate using SQL?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are routines in datastage? Enlist various types of routines.
How one source columns or rows to be loaded in to two different tables?
how to add a new records into source?
What is a ds designer?
Differentiate between datastage and datastage tx?
What are the different layers in the information server architecture?
How to find value from a column in a dataset?
What is difference between server jobs & parallel jobs?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
