Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a problem regarding incremental load on my attached excel file.
I have following fields in my excel :
Employee Id Varchar
Employee Name Varchar
Created Date Date
Modified Date Date
Created By Varchar
Modified By Varchar
Active Flag Varchar
I want to apply incremental load on Employee ID (Must Requirement) . And Have following conditions :
1 Incremental should be on Employee Id field.
2. New Emplyee Added with Created Date and Modified Date with , that day when it was created.With Active Flag Y
3. And if any employee deleted from previous data , then in QVD file i want that data with Modified Date as same date on which it was deleted with active flag N. Means i want to maintain the history data.
i am attaching my Excel file .
i have found this solution from my self.
You can fine the solution file at
Also attaching the QVS file for those who have personal edition.
Thanks all.
i have found this solution from my self.
You can fine the solution file at
Also attaching the QVS file for those who have personal edition.
Thanks all.