what are fact tables and dimension tables?
give example assuming one table.
Answer Posted / srikanth
Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain entity, attribute and relationship in datastage?
How do you import and export the datastage jobs?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Difference between data warehousing and olap?
Name the different sorting methods in datastage.
What can we do with datastage director?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the difference between == and eq in UNIX shell scripting?
Is it possible to query a hash file?
What is a folder? Difference types of stages?
Describe routines in datastage? Enlist various types of routines.
What are the components of datastage?
What is the project in datastage?
Define Routines and their types?
Lookup constraints