What is diff between Junk dimensions and conform dimension?
Answer Posted / nagireddy
a junk dimension is dimension but not using for
maping..like its a boolean value.but conform dimesion is
which dimension is shared by two or more than two fact
tables is called conform dimension.and conform dimesin
reduce the no of tables...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain ibm infosphere information server and highlight its main features?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the steps required to kill the job in Datastage?
How you can fix the truncated data error in datastage?
What is the sortmerge collector?
what is use of SDR function?
In Datastage, how you can fix the truncated data error?
Why we use surrogate key?
Can you explain kafka connector?
What is the difference between account and directory options ?
What are system variables and sequencers in datastage
What are constraints and derivations?
On which Dimension Table you implemented SCD Type in your Project
What are the functionalities of link partitioner?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)