What are the Advantages of de normalized data?

Answer Posted / mahesh

Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

scenario where i can use only concurrent execution of workflow.

2544


 Informatica Checkpoints

2857


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

603


Write the different tools in the workflow manager?

575


Explian the Process of deployment groups in informatica

659






What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7678


server hot-ws270 is connect to Repository B. What does it mean?

1855


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2297


Explain sessions and how many types of sessions are there?

584


Explain the use of aggregator cache file?

678


How do you set a varible in incremental aggregation

1446


What is mapplet in informatica?

597


Write the unconnected lookup syntax?

656


What do you understand by a term domain?

670


What are the data movement modes in informatica?

703