Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 12874 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
What is the session task and command task?
What is the use of code page?
Explain transaction control transformation in informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What happens when a session fails and you click on recover?
Why union transformation is an active transformation?
What are the differences between oltp and olap?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Plz can any one say me how to get the informatica certification materials and dumps
How to create Target definition for flat files?
What is status code in informatica?
What are the restrictions of union transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the use of target designer?
Explain the tuning lookup transformation - informatica
