what are fact tables and dimension tables?
give example assuming one table.
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 |
What is APT_DUMP_SCORE?
Differentiate between hash file and sequential file?
Differentiate between data file and descriptor file?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
What is the difference between passive stage and active stage?
source file contains 100 records, i want 10 records in target file how it possible in datastage
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What is meta stage?
If the job aborted in a sequencer, how can we start that from the previews successful job.
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?