Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8461 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kathyayini
fact table is the collection of foriegn keys corresponding
primary keys in the dimention tables
dimention table is the table which contains primary key and
will give detail informati1on about perticular instance
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
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.
types of errors in datastage?
how to export or import the jobs in .ISX file
What all are the different way to run a job?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
If the job aborted in a sequencer, how can we start that from the previews successful job.
What are the benefits of datastage?
how to do pergformence tuning in datastage?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
What are system variables and sequencers in datastage
Teradata 
