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
Name the third party tools that can be used in datastage?
Lookup constraints
What is the difference between in process and inter process?
What are the areas of application?
Define Job control?
What are the stages in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
root tree will find which is server job and which is parallel job?
What is apt_config in datastage?
What is the purpose of pivot stage and types of containers in datastage
What are the steps required to kill the job in Datastage?
How we can covert server job to a parallel job?
Define orabulk and bcp stages?
Define oconv () and iconv () functions in datastage?
What are transforms and what is the differenece between routines and transforms?