1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / subbuchamala


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

Can you filter data in hashed file?

0 Answers  

EXPLAIN SCD

0 Answers   CTS,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

What is the default execution order of the sequential file?

3 Answers  

What steps should be taken to improve Datastage jobs?

0 Answers  




What are the different type of jobs in datastage?

0 Answers  

How do you remove duplicate values in datastage?

0 Answers  

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

what are the different type of errors in datastage?

2 Answers   Wipro,

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

How can we achive parallelism

1 Answers   CTS,

For more Data Stage Interview Questions Click Here
Categories