Interested to Buy Any Domain ? << Click Here >> for more details...
who to split dimentions into sub dimention
- 3 Answers
- 7379 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 |
Why do you use Mapping Parameter and mapping variable?
What is Datadriven?
how to return multiple columes through through un-connect lookup?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
whats the logic to load the lower level of granularity of data to fact table.
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
explain abt joiner t/r?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
What is DR strategy for Informatica project?
what is degenerated dimension
Teradata 
