What is confirmed Dimension?
what is Factless Fact? give one example?
What are Additive, Semi-Additive Facts?



What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Addi..

Answer / srinu

The Dimension table which is shared by more than one fact
table is called confirmed dimension
Eg: Time Dimension

The fact table which doesn't have any fact information is
called factless fact table

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Data Stage Interview Questions

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

5 Answers   IBM,


which cache supports connected & un connected Lookup

1 Answers   Wipro,


What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,


Highlight the main features of datastage?

0 Answers  


if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,






Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,


what is flow of project?

0 Answers   HSBC, IBM,


Define orabulk and bcp stages?

0 Answers  


Why we need datasets ratherthan sequential files?

5 Answers  


I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,


how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,


Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,


Categories