Incre load for master as well

[#1]

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

[kaushiknsolanki]

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   

[#3]

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

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[#5]

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