Thanks for your quick answer. That's exactly what I thought. I think aCRM guys are a little bit lazy and don't want to make joins. Anyway, there are a couple...

Sorry for that, I realized that my question has a better forum category after I summited here. I don´t know how to erase the post from this forum category.

Kind Regards

Hi all,

Finally, I just erased the Ole Db destination, added a new one and that's all, problem solved. It seems like a sincronization problem between the metadata and the UI....

Hi zeeaay,

I´m facing the same problem. I opened the advance editor of every step and refresh the metadata but in the Ole Db Destination the metadata is wrong. I'm also...

Hi guys,

I know that this post is very old, but I´m facing the same issue. Does anybody solves it?

Kind Regards

Thanks so much GilaMonster:

I´m still waiting but now I´m able to calm down 🙂

I found this blog entry which shows how to determine aprox. how low does the database will...

Ok, I will try 🙂

First I load a table "A" with transactions from a particular week. Then I want to update a table "B" which cotains aggregated data from "A"....

Ok,

This question is very stupid, sorry for this.

The solution is very basic, I don´t need to select all the customers and then iterate one by one to perform the...

Ok, I think my initial explanation was not so gut. I will try to clarify the scenario.

Supose that in the Data Hub I have the following table with information about...

Hi Sugnu,

I now your post is a little bit old but i´m facing the same situation right now and I would like to know if you resolved this issue and...

Hi Chris:

I've found one of the problems. I was joining data from BRANCHE and KONSUMFELD using the columns branche and konsumfeld respectively. These columns are not unique, that's the reason...

Chris, you're simply amazing!!!

I've learned a lot from you today.

I'll study carefully your last reply, implement the changes and then write back to the forum to share my results.

Kind...

Hi Chris,

Attached the Actual Excecution Plan,

For other readers, I found this link very useful to understan execution plans from SQL SERVER: http://www.simple-talk.com/sql/performance/execution-plan-basics/

Kind Regards,

Paul

Hi Chris,

Attached you can find the execution plan (I've never used this feature, it seems to be very cool).

If you look at the first figure (from my 1st post) there...

Hi Chris,

Thanks so much for your quick answer.

My problem is I have to perform 3 Joins with 2 tables with the same situation and 1 table with a numeric...