why dimenstion tables are denormalized in nature ?

Answer Posted / siddu

For fast retrieval(to Perform a SELECT Operation)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is resilience time?

645


What are the main features of Oracle 8i with context to datawarehouse?

1668


How do you remove duplicate records in informatica? And how many ways are there to do it?

695


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1523


How to load data in informatica ?

558






How to load the name of the current processing flat file along with the data into the target using informatica mapping?

677


Design a mapping to load the cumulative sum of salaries of employees into target table?

880


hi real timers . iam waiting for ur reply regarding ETL TESTING

1791


Mention few advantages of router transformation over filter transformation.

626


Describe expression transformation?

623


How can we remove the duplicates from flat file source?

564


How would you join a node to the already existing domain?

665


Explain about Informatica server process that how it works relates to mapping variables?

612


How might you approve all mappings in the archive all the while?

590


what is the Default Source Option For Update Strategy Transformation?

743