Running Metadata Twice

[mastertito4]

I have noticed that sometime when I run a process to load a dimension (or two or three at a time) it runs throught the Metadata procedure twice.

I was just curious if anyone knew why it did that?

[lotsaram]

If you have code on the meta data AND data tabs then the source records will be processed twice (once for each tab). There is no way to process the meta data or data twice (there would be no point).

I think it is highly highly unlikely that the meta data is running twice. More than likely code on the data tab is causing the source data to be processed a second time. So the question is do you need the code on the meta data tab (eg. for updating attributes). If not then remove the unnecessary code and the source will only be processed once.

[mastertito4]

that makes sense, there is some code on the data tab which likely is making it run again.

Thanks!

[mastertito4]

It appears that The problem was fixed when I reordered the script in the metadata tab.

The first time around I just threw it all on there but when I stepped back and gave more attention to the order of the script, things were better ordered and Metadata only ran once