Interested to Buy Any Domain ? << Click Here >> for more details...
who to split dimentions into sub dimention
- 3 Answers
- 7488 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 is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
How to recover sessions in concurrent batches?
What is the difference between normal and bulk loading? Which one is recommended?
What is log file,and where is it located,why u r using the log file
can you use flat file for lookup table?why?
In target table how to display the system time
Explain load alternative records / rows into multiple targets - informatica
how to move the mappings from your local machine to claint place?
How can you change from reusable session into non-reusable session.
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
Can you create a flatfile target
Teradata 
