Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Big problem with ETL!!

Hello,

I´ve a simpele query in Oracle 10g, that retun 3675427 records.

When i´m running this query to ETL on Qlikview, they just returns 2.403.700 records.

It´s the same query!

What´s happend? Anyone seen that?

Thnak you

6 Replies
Not applicable
Author

Hi jgutheil,

as I don't think that you have any magic spells on your data, let's try to check this out:

- where does the numbers of loaded record come from (is 2.403.700 the count of rows in QV-table or is it the number taken from script progress window)

look at your two connections (qv and the other one)

- are you using the same ora-user for connecting to your ora-instance ?

- are you connecting both to the same instance ?

Regards, Roland

Not applicable
Author

Hi Roland,

Answering your questions.

1. The 'no of records' is in QVD file.

2. I´m using the same user, password and ora-instance.

I did a test with one single people code. There´s in a oracle database but not in QVD file.

Regards, JGutheil

Miguel_Angel_Baeyens

Hi,

Are you using any WHERE condition in your LOAD script that may reduce the number of records eventually stored in the QVD file? Does your ODBC driver or your database some fetch limitation so you have reached the maximum number of records the user or the driver can get?

Hope that helps.

Miguel

Not applicable
Author

Hi Miguel,

No, i´m not using any WHERE clause.

Thank you

JGutheil

Not applicable
Author

Hi Miguel,

And i´m using OLE DB driver.

Thks

Miguel_Angel_Baeyens

Hi,

Does any other query to any other table return a supposedly different number of records? Do something like the following to create a counter field in your script, so you can easily check the higher number:

Data:

LOAD *,

     RecNo() AS Counter;

SQL SELECT *

FROM DB.Table;

Once you have reloaded the script, create a text object and use the Max() expression to see the highest value in field "Counter"

=Max(Counter)

Do not any STORE for the time being. Does that return the expected value?

Hope that helps.

Miguel