-
what are the difference between view and materialized view?
pkshve
- Sep 13th, 2010
View is just a SQL statement stored in Database which is executed every single time its called.Materialized view (MV) is SQL statement and its resultant data stored in database in some form ...
Shekhar Pandit
- Sep 15th, 2006
DMLs can be used against view (if they are based on 1 table with no aggr funs)
-
Why we use partitioning the session in informatica?
Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.
khadarbasha
- Sep 30th, 2005
Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline.Informatica server can achieve high performance by partitioning the pipleline and performing the extract , transformation, and load for each partition in parallel.
