Answer Posted / mohini
the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the modules in Power Center
tell me about your project functionality
What do mean by local and global repository?
Explain informatica architecture - version 8 / 9
How do you handle two sessions in Informatica
How to improve the performance of a session using sorter transformation?
What is informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain the code page compatibility?
What is the need of an ETL tool?
What is powercenter on grid?
Explain the tuning lookup transformation - informatica
What is meant by query override?
What all join we can perform in LOOKUP transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?