Data Designer should dynamically honor lookups between tables

Oi - this would be extremely helpful functionality to have. +1

+1 agreed!

@minh_phan  @sai_ram may we get some detail on why this isn’t planned?  

One of the most difficult aspects of Data Designer is the fact that you have to manually add every single field you may need to use into the set, so if you want to be able to lookup to the Company table, for example, you have to select every Company field and pull it into your DD set - which can take up a lot of  the the 50-default limit field slots and results in duplicative data being stored in MDA.

It would be far more effective and efficient to provide the abiilty automatically establish lookups.

Would it really be that difficult to have a checkbox on GSID fields or SFDC ID fields that says “establish lookup?” and select and MDA table/field, and then inherits that capability?  You’re creating an MDA table - and MDA has the ability to perform lookups to other tables.  There has to be a way to do this.

Please reconsider this - it’s an administrative pain otherwise. 

@travis_floyd @heather_hansen  @keith_mattes your thoughts?

Likewise, I would like the ability to edit the DD table and add lookups manually if needed.  I basically have to build a giant flat table and merge in ANY data that I am going to need because I cannot configure lookups in a DD table.

One additional detail - when you have to manually select fields to which you need to lookup, and the designer set runs, it pulls the value of those fields at the run time.  This forces you to schedule all DD sets that require those fields to run at the minimum every 2 hours so that you have the most up to date information in that data set.   You still run the risk of having stale data, though, since it is not real time.

That is a side effect of the main issue though - the need to do dynamic lookups via DD sets would improve administrative overhead, data management and reliability.

+1 to this and any enhancements to DD :) Standard Lookups as well as JOINS to DD Dataspaces would be the coolest!!!!

Um, yes!  I can’t tell you how many times I’ve built a DD, and then, had to go back and add more fields or add another object into the set because I didn’t get everything with the first pass.  Honestly, I thought it was just me.  

@heather_hansen  you are definitely not alone!!  

@heather_hansen not at ALL alone.  Happens to me regularly.  Spread the word to your other GS admin contacts and lets get this upvoted!