Join transformation takes longer time

[Babloo]

Join transformation takes longer time to go complete. I'm joining (inner join) 7 SAS datasets and the excepted output is around 80K records. I don't see any errors in order by or where clause. But when I execute this transformation it keeps running and it neither fails nor completes. No useful information from the log too. 

Could someone of you help me to  know the possible cause for this issue?

[LinusH · Accepted solution]

With the given information no.
If the source tables are not big my guess is that your join condition is not correct.
Try with tiny data sets (3-4 rows in each) and evaluate the outcome.

[Ksharp]

Try to make index for these tables to speed up.