Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. myrcmstr

    Unusable/ Rebuild Index

    I disable index on huge table before loading. I load 500000 rows in that table. Then I enable index. Do I have to recreate index again to incorporate new 100000 rows? or rebuild index will update index with new rows?
  2. myrcmstr

    Index

    Will the indexes be updated with 'Update Statistics' without recreation?
  3. myrcmstr

    Index

    With Index drop and create it needs to create indexes from scrach. Can it be possible to update existing indexes?
  4. myrcmstr

    Index

    How to turn off index and turn on index? We have big fact table with 64 milion rows per month. To load this huge table I want to turn off index and after laoding i want to turn on index. How to do this through informatica/database?
  5. myrcmstr

    Few Questions

    1. What is the difference between Bulk/Normal/Insert mode? 2. How dynamic Sql is used in Informatica? 3. How cache is refreshed in Informatica? 4. What is reusable session in the workflow? What is it used for? 5. What is persistent cache in lookup ? 6. What is dynamic cache work in lookup ? 7...
  6. myrcmstr

    slowly changing dimension in microstrategy

    how to hsndle slowly changing dimension in microstrategy?
  7. myrcmstr

    Copy attributes/report from Test To Prod

    I am new to Microstrategy. I want to copy new report and its corresponding objects (attributes, filters, metrics etc) from Test to Prod. I know I can do this from Object Manager. But I see only two options in Objet Manager as 'Duplicate or Merge'. I want to copy only specific report and...
  8. myrcmstr

    Time Out Error

    I am getting 'time out error' while running the report. How can I solve this? What are the different ways?
  9. myrcmstr

    Using Oracle Materialized Views

    I am getting 'time out error' while running the report. How can I solve this? What are the different ways?

Part and Inventory Search

Back
Top