who to split dimentions into sub dimention
- 3 Answers
- 6354 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinu
make required column as primary-forign key relation then add
fields wt do u want
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kittu
It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the basic needs to join two sources in a source qualifier?
What is a test load?
what are the transformations that restricts the partitioning of sessions?
How many number of sessions can one group in batches?
what is the main advantage of unconnected lookup
Explain sessions. Explain how batches are used to combine executions?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Mention few advantages of router transformation over filter transformation.
how can import the data from the flat files?
can u any challenge your project?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Teradata 
