Thank you. You might also be interested in below 2 videos as well How to load dimension table in sql using ssis th-cam.com/video/c2lSKLQPb_I/w-d-xo.html How do you load a fact table th-cam.com/video/duaR_PhLdmc/w-d-xo.html
Hi Aqil, i have a question, on the historical Attribute Options both 'Start date column and End date column' are both blank on the dropdown. IS there something that i am doing wrong?
Right now I don't remember the steps for Slowly changing dimension. I rarely use it. The best method for incremental data load is using Lookup transformation to handle the SCD type 0, type 1 and type 2. You can watch below video to understand how this works th-cam.com/video/7uj463csru0/w-d-xo.html
thanks a lot for your great contrubution. i still need to see videos how to populate data into data warehouse /especally how to populate to fact table. share me the link for your video if you have it?
hello, i was try to record event handler in ssis but what is the system variable for errorrow? i tried (INSERT INTO dbo.ErrorLog (ErrorRow,ErrorCode,ErrorMessage,ErrorPackage,FileId) VALUES (?,?,?,?,?) select @fileid = SCOPE_IDENTITY() CREATE TABLE ErrorLog ( ErrorId INT primary key IDENTITY(1,1) ,ErrorRow VARCHAR (MAX) ,ErrorCode INT ,ErrorMessage VARCHAR (MAX) ,ErrorPackage VARCHAR (MAX) ,FileId INT FOREIGN KEY REFERENCES FileConfiguarion (FileId) )
hello, do you know how to write these three query in one statement? select transaction_date, sum(transaction_amount) AS totalcheckdeopsit from TransactionDetail where Transaction_Type = 'cqd' group by transaction_date ,transaction_amount order by transaction_date asc select transaction_date, sum(transaction_amount) AS totalcashwithdrawal from TransactionDetail where Transaction_Type = 'CW' group by transaction_date ,transaction_amount order by transaction_date asc select transaction_date, sum(transaction_amount) AS totalcashdeopsit from TransactionDetail where Transaction_Type = 'cd' group by transaction_date ,transaction_amount order by transaction_date asc
Actually for majority of my videos, I have given the link, sorry for this video the link was missing. I have provided the link in the description of this video, you can download the databases used in the video from this link.
Hi Aqil.. Thanks alot for this video. I have a question, why do we use surrogate key when we already have a Primary key in the dimesion table and that we can use as a foreign key in fact table. Thanks
This is an excellent way to create the dimensions. Great job!
Thank you. You might also be interested in below 2 videos as well
How to load dimension table in sql using ssis
th-cam.com/video/c2lSKLQPb_I/w-d-xo.html
How do you load a fact table
th-cam.com/video/duaR_PhLdmc/w-d-xo.html
very good explanation. Nice work
Thank you ParixitSingh Chauhan.
Hi Aqil, i have a question, on the historical Attribute Options both 'Start date column and End date column' are both blank on the dropdown. IS there something that i am doing wrong?
Right now I don't remember the steps for Slowly changing dimension. I rarely use it. The best method for incremental data load is using Lookup transformation to handle the SCD type 0, type 1 and type 2. You can watch below video to understand how this works
th-cam.com/video/7uj463csru0/w-d-xo.html
Video for hash and lookup transformation for scd concept?
This is the video for Lookup transformation for SCD concept, I don't have video for Hash for SCD concept.
th-cam.com/video/7uj463csru0/w-d-xo.html
Very helpful....Thank you so much
Thank you Sara.
can i get the data ?
Thank you for this video, please on English subtitle in this video.
Sure Riya, yeah need to work on subtitles.
thanks a lot for your great contrubution. i still need to see videos how to populate data into data warehouse /especally how to populate to fact table. share me the link for your video if you have it?
Sorry at the moment I don't have video to load the Fact table, I will work on it.
hello, i was try to record event handler in ssis but what is the system variable for errorrow? i tried
(INSERT INTO dbo.ErrorLog (ErrorRow,ErrorCode,ErrorMessage,ErrorPackage,FileId)
VALUES (?,?,?,?,?)
select @fileid = SCOPE_IDENTITY()
CREATE TABLE ErrorLog ( ErrorId INT primary key IDENTITY(1,1)
,ErrorRow VARCHAR (MAX)
,ErrorCode INT
,ErrorMessage VARCHAR (MAX)
,ErrorPackage VARCHAR (MAX)
,FileId INT FOREIGN KEY REFERENCES FileConfiguarion (FileId)
)
@@ethiotube4805 There is no System variable for ErrorRow.
@@learnssis thanks
hello, do you know how to write these three query in one statement?
select transaction_date, sum(transaction_amount)
AS totalcheckdeopsit from TransactionDetail
where Transaction_Type = 'cqd'
group by transaction_date ,transaction_amount
order by transaction_date asc
select transaction_date, sum(transaction_amount)
AS totalcashwithdrawal from TransactionDetail
where Transaction_Type = 'CW'
group by transaction_date ,transaction_amount
order by transaction_date asc
select transaction_date, sum(transaction_amount) AS totalcashdeopsit
from TransactionDetail
where Transaction_Type = 'cd'
group by transaction_date ,transaction_amount
order by transaction_date asc
hey man,
why dont you add links or scripts for initial setup?
Actually for majority of my videos, I have given the link, sorry for this video the link was missing. I have provided the link in the description of this video, you can download the databases used in the video from this link.
I really like your videos, do you train people? cos I want to take a class with you!
Sorry Evans I don't take the online classes.
Hello, could you give me the data source and scrip of this demonstration. thank you
What is your email id ? I will send you the files and database through email.
@@learnssis Can You please send the database and file to abhishek_01_01@yahoo.com
Awsomeeee!!!!!
Glad to know that you liked it.
Hi Aqil.. Thanks alot for this video. I have a question, why do we use surrogate key when we already have a Primary key in the dimesion table and that we can use as a foreign key in fact table. Thanks
For the Historical attribute there can be multiple records with the same primary key in Dim table, thus we use the Surrogate key for this.
After a long time.... :)
Actually last night I spent couple of hours in editing but something went wrong and I had to edit it again. Sorry for that.
hey do you take online classes by any chance?
Hi Ajay, Sorry I don't take the online classes.
thanks !!!
Thanks for your comment.