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 |
What are the different database update actions available?
can we half project in parallel jobs and half project in server jobs?
how to call routines in stages?
Define Job control?
If you want to use a same piece of code in different jobs, how will you achieve this?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
what is the function in Transformer stage can act as Rank function in Oracle
What are the difference types of stages?
how to define satge variables in transformer stage
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the difference between datastage and informatica?