Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anjalivnr
Contributor
Contributor
‎2021-01-20 10:13 PM

tDBSCD component - Addition of extra where clause

Hi Everyone ,

Im using tDBSCD component to implement SCD type 2 dimension. it is working fine. But for some reason. we are suppose to reprocess the old files , which caused the incorrect record to be the most recent one.

So business suggested to use a last updated timestamp field to identify the latest record.

Im not sure how can i include this condition in SCD component. Looking for any help.

Labels (5)
103 Views
0 Likes
2 Replies
Anjalivnr
Contributor
Contributor
‎2021-01-20 10:15 PM
Author

We are not suppose the delete the records in production and process again. trying to incorporate through logic which can handle this type of scenarios

103 Views
0 Likes
Anjalivnr
Contributor
Contributor
‎2021-01-20 11:26 PM
Author

@Shicong Hong​ . Any thoughts or suggestions.

103 Views
0 Likes