• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

SSIS and “Slowly changing dimension”

Dear all
I am starting to create my first SSIS solution
I heard that “Slowly changing dimension” will do the job for me how?

I want to detect all the new rows added or deleted or edited in specific table, so as far as I understood that “Slowly changing dimension” will do this job for me.

My question:
Is there any details explanation about how it works?
I need many samples preferred to be video

Thanks is advance



0
RamzyNEbeid
Asked:
RamzyNEbeid
  • 2
  • 2
3 Solutions
 
Alpesh PatelAssistant ConsultantCommented:
0
 
RamzyNEbeidAuthor Commented:
a lot of people is saying that Slowly changing dimension is very bad and very slow with large data?
0
 
RamzyNEbeidAuthor Commented:
what are other options to use instead of "Slowly changing dimension"
0
 
SThayaCommented:
Hi,

  you can use Look up Component .... by redircting rows we can achieve new records addition and old record updation

1. conncet the data source
2. connect with Look up tranfornation with the reference table as your destination table
3. Redirct the No matching Entries and move them to destination (it consider as a new record "Insert")
4. For Matching records  you can use the Execute SQL task to achive the update and the delete entries in the existing record .

Try this . it may usefull for u
 
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now