I have two database table that I want load incrementally each days. I have already use incremental qvd process to load the two tables using a classic Auto Incremant primary key an a filed UpdateDate on each database table.
But I want now merge these tables in one QlikView table. For information I must do incremental load with QVD files because I have more than 30 000 000 lines in my tables updtated each days, so all lines reload take too much time.
The table are like this:
Table A:
PKAutoIncremented
UpdateDate
FieldA
FieldB
Table B:
PKAutoIncremented
UpdateDate
FieldA
FieldB
I want this:
TableC:
FieldA+'-'+FieldB
And only different FieldA-FiledB Values in the table because I want use it as a referential inside QlikView and use the field FieldA-FiledB for auto join with another table.
I attempt to Load incrementally the Table A whith a first QVD in a table "referential", then the Table B on another QVD in a table "TmpReferential".
After it I want merge the two table for delete duplicated synthetic keys (FieldA+'-'+FieldB)
I am not sure if synthetic keys FieldA+'-'+FieldB could be processed correctly, I defined it in SQL query part, and use the true primary key of each database table for incremental loads. I know Synthetic keys aren't stored in Qvd.
I think it's possible with some JOIN clause, but in my tests I have issues on final QlikView table mapping with an other table on my synthetic key (all unmatched. Or perhaps duplicate values which create error on mapping?).
With only the first table A no mapping or incremental load problem. When I attempt to merge two table A and B I have no mapping.
After many try, I haven't solved this mapping/merging issue.
With Ctrl+T command I see that th QlikView merged tables result display only NULL value on the synthetic key FieldA+'-'+FieldB
Consequently I merged my tables directly in database and use an autoincrement Primary key on the result table as key for the auto increment Load procedure.
