Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13080 Views
- I also Faced
- E-Mail Answers
Answer Posted / anju
materialized view can be used to precalculate the expensive
joins and aggregates prior to execution and the result is
stored in a table in database and can refer to it in
future. the adv of this is increse in performance.
view is nothing but an sql query stored. it will not store
data in tables
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are batches?
How do you load only null records into target?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you mean incremental aggregation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Clarify the utilization of aggregator cache record?
What is standalone command task?
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 ?
Performance tuning in UNIX for informatica mappings?
What is event and what are the tasks related to it?
Explain informatica architecture - version 8 / 9
