Give example for FACTLESS FACT TABLE in real-time scenario.
Answers were Sorted based on User's Feedback
Answer / viswa
Factless table means only the key available in the Fact
there is no measures available.
Is This Answer Correct ? | 14 Yes | 6 No |
Answer / ram
for ex:%discount in retail project
studant Attendance
Is This Answer Correct ? | 8 Yes | 5 No |
Answer / usha
FACTLESS FACT TABLE means a FACT table with out measure.
ex:student registration details
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / satyam
genarelly fact table contains keyvalues and mesures products like that,fact less means it contains measures only so example in real time %discount,student monthly %of attendence like that ok,i think its a right once according my knowledge
Is This Answer Correct ? | 7 Yes | 5 No |
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to find no.of records in sequntial file itself?
What all are the different way to run a job?
can any one tell me how to install datastage 8.1 in windows xp with wizard
what is the diff between sequential file and fileset stages?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
State the difference between an operational datastage and a data warehouse?
Can you highlight the main features of ibm infosphere information server?
what is the use of surogate key in datastage
Can you explain repository tables in datastage?
how can or from where we can get reference data in scd type2 implementation?