Data Modeling Assistant

[Eddie S]

Hey All,

Does anyone know what the "Refresh Chunks" button does in the Data Modeling Assistant??

[Tony Tillyer]

AFAIK, this will only refresh the DMA display to show any "new" chunks which have been updated via the ETL. It does not force a new set of chunks to be created if that is your intention, then you would need to invoke a Java Script for ETL to transform offline this, in turn would need you to take your current ETL Assistant Solution offline before doing so, otherwise you will find you have conflicting Java Sessions running against your ETL.

...Too much info? lol

Tony

[Eddie S]

That makes sense.

Thankyou for your assistance.

Eddie S

[ecki]

Hi Tony,

Please correct me if I am wrong, but I thought ETL has nothing to do with DMA, only that ETL transfers chunks collected by Datasourcer. Has this been changed in version 7.1?

Thanks.

[Tony Tillyer]

ecki,

For clarification, ETL data processing is *displayed* by DMA, by showing the Chunks in transit and indicating whether a Chunk has been succesfully collected, transferred and then deleted. Whilst DataSourcer does the processing work via ETL/Java, DMA acts as a GUI, much the same as ETL Assistant would, if it is installed.

The extra "blurb" I put in my response is in relation to a scenario whereby you might want to manually "kickstart" ETL via ETL Assistant, in which case you must stop the ETL Service and wait for any spawned Java processing to cease before manually starting a Java Script to run a specific ETL command.

In short, DMA cannot affect ETL processing but provides indications that the processing taking place is actually working (or not).

I hope I have now made this clear?

Tony