Hi,
Anybody can help me, how to do Inner Join to Oracle without loading all record first.
for example I have script like this :
GET_ALL_INVESTOR:
LOAD
"@1:20" as INV_SID,
"@23:42" as INV_SEC_ACC,
"@45:49" as INV_AB_ID,
"@104:303" as INV_NAME,
'0' & "@360:399" as INV_ACCT_NO,
"@402:415" as INV_ACCOUNT_STATUS
FROM [lib://MIS_Folder/Dashboard_SCM\Investor_All.txt]
(fix, codepage is 1252, no labels, header is 16 lines)
where Match("@402:415", 'CLOSE', 'OPEN');
inner Join(GET_ALL_INVESTOR)
Load CUST_NO,
ACCT_CARD_NO as INV_ACCT_NO,
ACCT_NAME,
ACCT_STATUS;
SELECT a.cust_no, a.acct_card_no, a.acct_name, a.acct_status
FROM ACCT_DIM a;
There are 50 million records in table Acct_Dim.
Right now, it looks like Qliksense load 50 million records to memory and then start doing inner Join.
Is there any way to load only the data from ACCT_DIM where ACCT_CARD_NO in file Investor_All.txt ?
Thanks
