Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Merge Join is not working properly

Merge Join is not working properly

Merge Join is not working properly

Hi there smile 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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close