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 friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
what is Audit table?Have u use audit table in ur project?
What is use Array size in datastage
What is the difference between an operational datastage and a data warehouse?
why we use hash file for lookup?
when will you go for dataset and fileset?
How to reverse the string using unix?
how many types of remove the duplicate records?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
how to delete one row in target dataset
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
table actions available in oracle connector?