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?
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.