what is factless fact table?
Answers were Sorted based on User's Feedback
Answer / madhusudhan reddy.d
A fact table without any facts is known as factless fact
table. Always a Fact should be a Numeric value but every
numeric value need not be a fact.
| Is This Answer Correct ? | 13 Yes | 0 No |
In which situations we can use normal and sparse lookup stages
what is executable in DataStage?
What is the difference between Datastage 7.5 and 7.0?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
Nls stands for what in datastage?
what is the use of surogate key in datastage
What is "fatal error/rdbms code 3996" error?
Describe the main features of datastage?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
What is quality stage?
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