CamiloXVIIIv2.0
Programmer
Hi there 
I really need some help and I thought, and will be really glad, you can help me. I am at college learning about BI and SQL Server Data Tools. Actually, I'm working on a class project and we need to create a FactTable with its respective Dimensions (also, we need to implement the updating process of both elements). As for now I'm just starting to fill the DW with the Dimensions, in order to create the FactTable, however Im having some issues while doing this. My project is about projects (a little redundant) so those projects have an ID (some of them are only numbers some others are mixed) and I have stored those IDs in a varchar column. Aprox. 7000 registers (repeated registers because one project ID can have subcodes... and so on) and through a Merge Join Im trying to bring the budget of that specific project ID as many times it is required. I mean, it doesnt matter that the project ID is repeated, just bring it and it into a new column. This is working perfectly for those registers with numeric project ID but for others, i.e. project ID 876GHY the DataFlow is not bringing anything, just NULL. I also tried to do a Lookup but it is not working properly.
Any advise you can provide me with? Id really appreciate it.
* Sorry if I didnt keep it short!
Have a nice day everybody.
I really need some help and I thought, and will be really glad, you can help me. I am at college learning about BI and SQL Server Data Tools. Actually, I'm working on a class project and we need to create a FactTable with its respective Dimensions (also, we need to implement the updating process of both elements). As for now I'm just starting to fill the DW with the Dimensions, in order to create the FactTable, however Im having some issues while doing this. My project is about projects (a little redundant) so those projects have an ID (some of them are only numbers some others are mixed) and I have stored those IDs in a varchar column. Aprox. 7000 registers (repeated registers because one project ID can have subcodes... and so on) and through a Merge Join Im trying to bring the budget of that specific project ID as many times it is required. I mean, it doesnt matter that the project ID is repeated, just bring it and it into a new column. This is working perfectly for those registers with numeric project ID but for others, i.e. project ID 876GHY the DataFlow is not bringing anything, just NULL. I also tried to do a Lookup but it is not working properly. Any advise you can provide me with? Id really appreciate it.
* Sorry if I didnt keep it short!
Have a nice day everybody.