1 of 1 people found this helpful
Depending on the data blending relationships you've established, or haven't established, you'll see asterisks if there isn't a valid relationship between your data sources or if the relationships established cause the data in the secondary data source to become aggregated in a way that doesn't make sense.
I think the following documentation will be helpful:
One more help please,
when i blend two datasources on two fields, and i am using only one field from secondary datasource. Its taking more that 30 mins to compute, but still i am not getting results.
What can cause this much time to compute.
It all depends on the dimensions that you're establishing the relationships on and the number of members in each dimension. Depending on all that, you could be generating a very large number of row-level computations that are all being performed locally on your machine (which may or may not be resource constrained).
It sounds like you may need to establish the relationships based on different dimensions at a higher level of aggregation in order to reduce the row-level computations. It should be worth noting that data blending isn't meant to be utilized for row-level type joins (Understanding Data Blending).
If your two data sources are actually coming from the same database, then it will definitely be better to join tables (Joining Tables) to allow the database to handle all the joining.