Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator
‎2020-01-20 04:16 AM

Oracle Extract is very slow

Extracting data from  oracle view in QlikSense (Qlik Ver - Nov 2018 patch 6 release)  which is taking too much time to load . I am using OLEDB as a data connection and for 18 million data taking 3-4 hours. 

In the oracle query I have group by and grouping set both keyword used, that might be one of the reason.

How to overcome this situation? Can anybody suggest any ideas?

Labels (3)
Labels
660 Views
0 Likes
1 Reply
anushree1
Specialist II
Specialist II
‎2020-01-20 06:43 AM

Usually using Queries as is in Qlik takes time , so its suggested to convert it to Qlik Native  in the Script and then load. 

 

 

632 Views
0 Likes