Answer Posted / srinu
one fact table is surrounded by different dimension table
and dimension table relation with master dimension table is
called snowflake schema (or) extended star schema
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
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.
What are the types of containers in datastage?
To see hidden files in LINIX?
How do you start developing a datastage project?
How do you import and export data into datastage?
Is possible to create skid in dim,fact tables?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is the sortmerge collector?
What is aggtorec restructure operator?
What are the types of jobs we have in datastage?
What is datastage?
How a routine is called in datastage job?
How can we improve performance of data stage jobs?
What is the use of datastage designer?
How many types of hash files are there?