Whatis the difference between View and Materialized View ?
- 11 Answers
- 53051 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / roshan
apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
How to handle decimal places while importing a flatfile into informatica?
What is domain in terms of informatica?
How to join three sources using joiner? Explain though mapping flow.
How does the aggregator transformation handle null values?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the features of connected and unconnected lookup.
What is a joiner transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a sequence generator transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain the different dimensions.
what is mean by complex business rule ?
which one is better performance wise joiner or look up
