Binary Load

[#1]

Hello,

I have a question:

I load data with the help of a binary load command. Is it possible to load just a special type
(one selling area, couple of products, etc.) of the whole binary data model, so
that the needed data model becomes smaller and the performance gets better.

Joachim

[swuehl]

I don't think that you can set constraints to the binary load directly (like a where clause in a LOAD).

If the creation of a different source file or usage of qvd's instead of a binary load is not an option,

I can only think of doing data model changes after the binary load, maybe using resident loads with a where clause and dropping the original tables.

You might also consider using a Macro to select your subset of data and then reduce the data after reload.