what is factless fact table?

Question Posted / guest

3 Answers
8374 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is factless fact table?..

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

what is factless fact table?..

Answer / srinu

a facttable relation with dimension table as
forgienkey,bussiness transaction data and without facts is
called factless fact table

Is This Answer Correct ?

2 Yes

0 No

what is factless fact table?..

Answer / chaitanya

The fact table without any facts is called the factless fact
table.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers Wipro,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers IBM,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers HCL,

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers Teradata,

how to retrive the max(sal),deptno,empno in datastage?

13 Answers Polaris,

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers TCS,

What is Fastly Changing Dimension?

6 Answers TCS,

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers Wipro,

Differentiate between hash file and sequential file?

0 Answers

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers IBM,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers TCS,

Terminate Activity

0 Answers CTS,

For more Data Stage Interview Questions Click Here