Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have FACT_GL_Entry_temp_init.qvd which is very big size and while loading I want to take only latest
information old history is maintained in FACT_GL_Entry_temp_init.qvd , Using Incremental load I want to create
FACT_GL_Entry_temp.qvd along with fresh data as well if there change in data from old history data should get updated
I think incremental load will work for this any body have incremental load from QVD and store modified data from historical and fresh data from transactions.
I am attaching my script
Vikas
is there a unique key identifying every record? if yes, you should use that in a exists function to load only new data. See attached example.
@See the attached file