Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Ferrari Mudiripoyina Bewarse Username: Ferrari Post Number: 10400 Registered: 09-2010 Posted From: 98.240.141.193 Rating: N/A Votes: 0 Posted on Friday, January 03, 2014 - 1:26 pm:    Lenevo: konchem clear ga explain cheyandi bro .. i can help. bro..basic gaa my lookup table has around 500 mil records..everyday's source flat file will have around 200k records...my mapping is simple source->lookup->exp->filter->target...cached lookup use chesthunnanu...in 500 mil records only 70 mil records are needed...so i used lookup override to get 70 mil records..but the session is running for around 2 hours still no progress(only caching going on)...the session log's last message is "Query issued to database"..idi matter...did i provide you enough details Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar