What is diff between Junk dimensions and conform dimension?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Junk dimension: This dimension is mainly used for reference
purpose. It contains textual codes and flag variables.
Ex: country_id,Country_name
IND INDIA
Conform dimension: AS Avinash said the dimension table which
is shared by multiple fact tables are called as Conform
Dimension table.
Date,Geography,time etc.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
what is set mapping in datastage??
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
Demonstrate experience in maintaining quality process standards?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
what is the use of materialized view?
How many jobs in ur project? Explain any complex job u have done in ur project?
Explain connectivity between datastage with datasources?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?