Selective Data Refresh

[Anonymous]

My full data refresh takes many hours. I now need to add a small lookup table. Is there a way in which I can simply bring the lookup table without reloading all the tables in the document?

Thanks,

Dinesh.

[#2]

Use the REPLACE command in your load and then do a Partial Reload.

REPLACE LOAD * FROM...

[Anonymous]

I currently do not have a load statement. All I have is ODBC connect. Then SQL Select statements. Do I have to comment out the SQL select of big tables & add REPLACE LOAD? What is the syntax of REPLACE LOAD?

Thanks,

Dinesh

[#4 · Accepted solution]

The REPLACE can precede a LOAD or SELECT. Just use REPLACE SELECT...