In Informatica there is a stored procedure transform (runs any Oracle SP) that you can make it "pre source load". So the SP would be called before loading the table.
Regards, Waleed -----Original Message----- Sent: Monday, October 14, 2002 7:04 PM To: Multiple recipients of list ORACLE-L Hello All, This problem pertains to local bitmap index in dw env. We are using informatica to load our fact tables. i have a fact table partitioned on period key (range partition). We have built local bitmap indexes on the foreign keys. During the loading of the fact table for month 1, we are making the local bitmap index partition pertaining to month 1 as UNUSABLE (through stored procedure being called at just before the target is being loaded). In that same procedure we also set ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE. Once informatica starts to load the target, it opens up a new session which in turn invalidates the alter session and hence oracle terminates with an error saying "0ra-1052 index in unusable state" Please let me know if there is any workaround to this. Is droping and recreating the bitmap index the ONLY option ???. this fact table is going to grow to about 150 mill rows in 12 month time frame , avg row length being 100 bytes) oracle ver 9.2., TIA, sathish. -- http://fastmail.fm - The way an email service should be -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
