Yes that can be done. Essentially this is then extending the existing dimension?

• This reply was modified 3 years ago by  eseosaoregie.

@JeffModen @Brian. Thank you for the responses.  Regarding the warning, it indeed comes from a different query. There are quite a few inserts that I am doing and...

Many thanks. Precisely what I needed

I have brought up the idea of a datamart on several occasions but there seems to be a reluctance particularly from the chief architect to deviate from the DataVault model....

The schema of the database is from an old AX4 application that is currently been to be upgraded to AX2012. The combination of a poorly designed forms and schemas allowed...

I opted for the multiple update option. It is added to a larger clean up job that will run at night. It ran very quickly and gave the desired result....

Apologies for responding so late.

I will give some of the suggestions a try. I agree with the comment about the database structure but to cut a long story short...

Thanks for your response. That is just what I wanted.

Oh sorry. The criteria is a join on The recid and then pull out The name.

I worked out what the issue was. I was executing the package from SSSM from the development server and not the SSIS server. I executed it from this server...

Hi guys,

Just to let you know that running the script within SSIS as mentioned above got the query time down to 45 secs.

thanks

Hi Guys,

I have managed to make some headway with the long running query. In the first instance I took the advice J Livingston and indexed the source tables. With this...

Thanks for the explanation. After reading it I realized that I knew it as another name, open schema. Will let you know how I get on.

Hi Jeff, thanks for your reply. I will give this a go when i am back at the office. Just one question for future reference. What is an EAV table?

Hi guys,

thanks for the responses. I will try that alternative approach and let you know what my results are. CLR came up when I was discussing this with a colleague...