Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between Junk dimensions and conform dimension?
- 4 Answers
- 12681 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / shar
junk dimensions are dimensions that contain miscellaneous data like flags,gender,text values etc that cannot be used for generating reports
Conformed dimension: if a dimension table is shared by multiple fact tables then that table is called as conformed dimension table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Differentiate between datastage and informatica?
What are the different options associated with dsjob command?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the use of datastage designer?
What are the stages in datastage?
Is the value of staging variable stored temporarily or permanently?
project Steps,hits, Project level HArd things,Solved methods?
What are orabulk and bcp stages?
Define ds designer?
What are the different layers in the information server architecture?
How can we improve performance of data stage jobs?
Why we use surrogate key?
how to implement scd2 in datastage 7.5 with lookup stage
