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
what is use of SDR function?
How can you write parallel routines in datastage PX?
If you want to use the same piece of code in different jobs, how will you achieve it?
EXPLAIN SCD
How do you reject records in a transformer?
CHANGE CAPTURE
What are datastage sequences?
What is the method of removing duplicates, without the remove duplicate stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is ds designer?
How to Remove Duplicate using SQL?
What is use Array size in datastage
Explain entity, attribute and relationship in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Whats difference betweeen operational data stage (ods) and data warehouse?
