What is diff between Junk dimensions and conform dimension?
Answer Posted / avinash
JUNK DIMENSION
A Dimension which cannot be used to describe the facts is
known as junk dimension(junk dimension provides additional
information to the main dimension)
ex:-customer add
Confirmed Dimension
A dimension table which can be shared by multiple fact tables
is known as Confirmed dimension
Ex:- Time dimension
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the use of datastage designer?
What are the functionalities of link partitioner and link collector?
Why fact table is in normal form?
What is the purpose of pivot stage?
What are the repository tables in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the difference between server job and parallel jobs?
What are the various kinds of the hash file?
Difference between in process and inter process?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are stage variables and constants?
What is the difference between orabulk and bcp stages?
What is the difference between datastage and informatica?
Explain entity, attribute and relationship in datastage?
How to manage date conversion in Datastage?