Incemental load issue

[#1]

Hi all,

I have a couple of fact tables  where i don't have any datefield to incremental load, but i have primary key like somesequential id.

my doubt how can i do incremental load without datefield in that table.

sequentail id format:1614/00003478,

                              1514/00005678

like that

Please help me how to incremental load using sequence id alone..

Thanks in advance

[Kushal_Chawda · Accepted solution]

Table:

SQL SELECT *

FROM Table;

concatenate(Table)

LOAD *

FROM Tablename.qvd(qvd)

where not exists([sequentail id ]);

Store Table into  ..\Tablename.qvd;

[effinty2112]

Hi Vijay,

               Does 1614/00003478 come before 1514/00005678? Do the different prefixes mean that you have two (or more) different number sequences?

Cheers

Andrew

[#4]

no it will not come like that ,1615 will come after that only

[gautik92]

replace that / and try lik this

Replace(sequentialid,'/','')