What is diff between Junk dimensions and conform dimension?
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
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Distinguish between informatica & datastage. Which one would you choose and why?
Can you explain link buffering?
What is a quality stage in datastage tool?
What are iconv and oconv?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to convert RGB Value to Hexadecimal values in datastage?
Define Data Stage?
Define APT_CONFIG in Datastage?
How a routine is called in datastage job?
Terminate Activity
What is the difference between passive stage and active stage?
How to reverse the string using SQL?
what is flow of project?