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 could be a data source system?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the various kinds of containers available in datastage?
Define oconv () and iconv () functions in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between datastage and informatica?
What is datastage?
How do you register plug-ins?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Where the datastage stored his repository?
What is the difference between account and directory options ?
How do you import and export data into datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Difference between server jobs & parallel jobs?
Can you filter data in hashed file?