Interested to Buy Any Domain ? << Click Here >> for more details...
who to split dimentions into sub dimention
- 3 Answers
- 7442 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 |
Diffrence between 7.1,8.1 and 8.6
which quality process u can approach in ur project
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to start a workflow using pmcmd command?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
What is rank transform?
Clarify the utilization of aggregator cache record?
can we use self join in informaitca?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What does reusable transformation mean?
Teradata 
