SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Join transformation takes longer time

Accepted Solution Solved
Reply
Super Contributor
Posts: 625
Accepted Solution

Join transformation takes longer time

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?


Accepted Solutions
Solution
‎04-20-2018 06:14 AM
Super User
Posts: 5,850

Re: Join transformation takes longer time

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.
Data never sleeps

View solution in original post


All Replies
Solution
‎04-20-2018 06:14 AM
Super User
Posts: 5,850

Re: Join transformation takes longer time

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.
Data never sleeps
Super User
Posts: 10,686

Re: Join transformation takes longer time

Try to make index for these tables to speed up.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 127 views
  • 2 likes
  • 3 in conversation