data-warehouse-science.blogspot.com
Science of Data: June 2010
http://data-warehouse-science.blogspot.com/2010_06_01_archive.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Friday, June 25, 2010. Can a Oracle parallel hint be evil? About Oracle query hint, this is often said that - "An hint, if ignored by Oracle, is just a comment". But I didn't think that a "mere" hint can lead to a job failure also. But I was wrong. Very Very wrong. I put the question to Tom Kyte's forum asktom and here. Is the answer I got,. Google Insight...
data-warehouse-science.blogspot.com
Science of Data: August 2010
http://data-warehouse-science.blogspot.com/2010_08_01_archive.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, August 30, 2010. Should we keep Index and Data in separate tablespace? Index and Data in Separate Tablespaces. While DBA wants developers to change the code to create the indexes in the proper tablespace, developers’ argument is why creating indexes in a different tablespace are so important? Why do you need a separate Tablespace for Indexes? There...
data-warehouse-science.blogspot.com
Science of Data: March 2011
http://data-warehouse-science.blogspot.com/2011_03_01_archive.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, March 12, 2011. List of Fourth-coming articles in DWBIConcepts.com. Currently working on the following articles for www.DWBIConcepts.com:. 1 A primer on Informatica MetaData Repository Tables. 2 Benefits and troubles of Informatica Persistent Cache. 3 Writing SQL Query to extract simple information from Informatica Metadata tables.
data-warehouse-science.blogspot.com
Science of Data: July 2010
http://data-warehouse-science.blogspot.com/2010_07_01_archive.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, July 10, 2010. Compare between CTAS, COPY and DIRECT PATH Load in Oracle. OK Here is a simple task that I am trying to achieve all through out tonight. Loading Huge Table Over DBLINK. When I started to think about this, following options came into my mind:. 1 Using Transportable Table Space. 2 Using CTAS over DBLink. 3 Using direct load path.
data-warehouse-science.blogspot.com
Science of Data: Can a Oracle parallel hint be evil?
http://data-warehouse-science.blogspot.com/2010/06/can-oracle-parallel-hint-be-evil.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Friday, June 25, 2010. Can a Oracle parallel hint be evil? About Oracle query hint, this is often said that - "An hint, if ignored by Oracle, is just a comment". But I didn't think that a "mere" hint can lead to a job failure also. But I was wrong. Very Very wrong. I put the question to Tom Kyte's forum asktom and here. Is the answer I got,. Parallel PL/SQ...
data-warehouse-science.blogspot.com
Science of Data: April 2010
http://data-warehouse-science.blogspot.com/2010_04_01_archive.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, April 19, 2010. Saurav has posted a new article here. On Incremental Aggregation Using Informatica. The need of incremental aggregation arise when we capture our source data (transactional data) incrementally in a frequency faster than the aggregation period. Sunday, April 18, 2010. 1 Detail Oracle Server Architecture. Let me know your comments.
data-warehouse-science.blogspot.com
Science of Data: List of Fourth-coming articles in DWBIConcepts.com
http://data-warehouse-science.blogspot.com/2011/03/list-of-fourth-coming-articles-in.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, March 12, 2011. List of Fourth-coming articles in DWBIConcepts.com. Currently working on the following articles for www.DWBIConcepts.com:. 1 A primer on Informatica MetaData Repository Tables. 2 Benefits and troubles of Informatica Persistent Cache. 3 Writing SQL Query to extract simple information from Informatica Metadata tables.
data-warehouse-science.blogspot.com
Science of Data: Compare between CTAS, COPY and DIRECT PATH Load in Oracle
http://data-warehouse-science.blogspot.com/2010/07/compare-between-ctas-copy-and-direct.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Saturday, July 10, 2010. Compare between CTAS, COPY and DIRECT PATH Load in Oracle. OK Here is a simple task that I am trying to achieve all through out tonight. Loading Huge Table Over DBLINK. When I started to think about this, following options came into my mind:. 1 Using Transportable Table Space. 2 Using CTAS over DBLink. 3 Using direct load path.
data-warehouse-science.blogspot.com
Science of Data: Should we keep Index and Data in separate tablespace?
http://data-warehouse-science.blogspot.com/2010/08/index-and-data-in-separate-tablespaces.html
This blog publishes supplementary discussions on articles published in DWBI Concepts. Along with anything related to data warehousing, BI and my life! Monday, August 30, 2010. Should we keep Index and Data in separate tablespace? Index and Data in Separate Tablespaces. While DBA wants developers to change the code to create the indexes in the proper tablespace, developers’ argument is why creating indexes in a different tablespace are so important? Why do you need a separate Tablespace for Indexes? There...