topic Incre load for master as well in QlikView

Incre load for master as well

Mon, 06 Feb 2012 11:28:10 GMT

Hi Kaushik

Table 1: having timestamp pkey, the transction table.

table 2:master table having deptno and deptname,also having timestamp col

these two tables linked by deptno. till now i was using the qvds of these tables. Now i want to set up an incre. load. for future.

its okay if i had only table1(using QV ref. manual incre load for Insert,Update,Delete) but if in future some new dept has to be added to table2 or some dept renamed(updated) or deleted.

then how to do this.

thanks

Incre load for master as well

kaushiknsolanki — Mon, 06 Feb 2012 11:39:38 GMT

Hi,

For that only thing you need to do is add the new dept in master table. It will link to your transaction table as you will be having the transaction data for new dept.

Now for dept whoes names are changed then you can change the master table with just name of that dept., but dept id might be same so it will properly link to your transaction table.

Now if any dept id deleted then you can load the table from master data with all dept except the one deleted and again store that in to the same qvd.

Regards,

Kaushik Solanki

Incre load for master as well

Mon, 06 Feb 2012 12:00:20 GMT

Hi,

Could you plz tell me how to satrt with the incre load script. I'm a bit confused abt the Modification time variable & the Last exectime variables used in the where clause of the select st given in the ref manual pdf

where & how shud i declare these?

Thanks

Incre load for master as well

kaushiknsolanki — Mon, 06 Feb 2012 12:02:12 GMT

Hi,

If you can send me the table structure i would defiantly tell you how to start and where to start.

Regards,

Kaushik Solanki

Incre load for master as well

Mon, 06 Feb 2012 12:09:38 GMT

Table 1: pkey is timestamp & other fields and also deptno(fkey to table 2)

master(Table 2): pkey deptno, only 2 other fields: timestamp & deptname