Skip navigation
Contact Us
1327 Views 4 Replies Latest reply: Sep 30, 2013 11:25 AM by Swapnil Saxena RSS
Abhi K Newbie 2 posts since
Sep 12, 2012
Currently Being Moderated

Nov 14, 2012 7:30 AM

Lookup taking time in finishing up

Hi everyone

 

I have a look up table with this lookup override

 

SELECT RAW_SPIRIT_HTL_CXL_POL.TXT as TXT, MAX(RAW_SPIRIT_HTL_CXL_POL.BEG_DT) as BEG_DT, RAW_SPIRIT_HTL_CXL_POL.HTL_KEY as HTL_KEY, RAW_SPIRIT_HTL_CXL_POL.RP_KEY as RP_KEY

FROM

RAW_SPIRIT_HTL_CXL_POL INNER JOIN RAW_SPIRIT_BOOK_SEGMENT

ON

RAW_SPIRIT_HTL_CXL_POL.HTL_KEY = RAW_SPIRIT_BOOK_SEGMENT.HTL_KEY

and RAW_SPIRIT_HTL_CXL_POL.RP_KEY = RAW_SPIRIT_BOOK_SEGMENT.RP_KEY

and RAW_SPIRIT_BOOK_SEGMENT.DOA > (select LAST_UPDATE_DATE from CONTROL

where PROCESS_NAME = 'm_edw_reservation_reminder_email_extract')

GROUP BY

RAW_SPIRIT_HTL_CXL_POL.TXT,

RAW_SPIRIT_HTL_CXL_POL.HTL_KEY, RAW_SPIRIT_HTL_CXL_POL.RP_KEY ----

 

and i'm getting this message in session log

And is taking lot of time for the session to finish up.

 

Any suggestions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points