Search results for query: *

It may be funny to ask how to set it to execute on open, butI am gonna ask you, coz I am zero at VBA and macros. Please gimme your advice. TIA

I created macro suggested by typeslowly and saved with this report, but how to run macro automatically once you open the document? any idea?

I thought this forum is for ETL tools, and as per I know Oracle Warehouse builder is an ETL tool. That is why I asked this simple question, thought there may be some GURU of OWB here. But anyway thanks for your suggestion.

does anyone have idea about answer of my question>

Please help me in this regard. It is creating lot of problem specially with staging area tables, which don't have any updates.

In the Mapping Configuration. go to the Runtime parameters and select "None" for Default Audit level. I think it should work then, because if the auditing is on then it requires run tiem tables to populate statistics of run. Try that and let me know, if works. Good luck Manish

Hi ETL GURUS My DBA checks all the stuffs goes to production very presicesly. I have a table created through Oracle Warehouse builder, but DDL of that table uses default PCTFREE & PCTUSED values for database, which I don't want to put. Is htere anyway in OWB I can specify PCTFREE & PCTUSED...

Put the Commit Frequency as ZERO in the configuration of mapping, in this way once the mapping will be over, then it will commit automatically at last. Hope this helps

MathOh I am agree with you with few possibilites that data is character or number then I can easily put Space(' ') or "No value" or 'Unknown' or '0'. but I have some date field which have null values and these are valid values like Person's Termination dates or Probation End dates...

I have a table which I have to maintain as SLOWLY changing dimension. That table has 20 columns and 10 columns I need to match before inserting a new row. I was trying to use OWB mapping to do that, but when one of the column has got null values then it inserts a new row even though column was...