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 apt_config in datastage?
what is ds administrator used for?
What are the different plug-ins stages used in your projects?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the roundrobin collector?
What is job control?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is merge stage?
what is the use of materialized view?
What are stage variables, derivations and constants?
If you want to use a same piece of code in different jobs, how will you achieve this?
Which commands are used to import and export the datastage jobs?
Define project in datastage?
Explain entity, attribute and relationship in datastage?
what is the use of skid in reporting?