Hi Nag, Thanks for this info. Question, how can we distinct records before inserting to the destination table to make sure that there's no duplicate records? can we do that in data flow ? Thanks advance for the answer
I don't think any transformation in SSIS to return distinct values. Workaround is using sort transformation to remove duplicate. Check box to remove rows with duplicate values. This will have a performance impact. Better use distinct from source or after loading into target with duplicate, use procedure in control flow tasks to remove duplicate. Use views for upstream system
Watch this video. Answer in this video. KNOW WHY !!! Power BI alone NOT enough to get a JOB [ Most asked Question to US] th-cam.com/video/CEZEwAocB9Q/w-d-xo.html
@@AnalyticswithNags thanks ji..I have a doubt jii..I know powerbi..which etl tool will be better to learn..ssis or informatica ji..I am following your ssis tutorial..if ssis,what should I start learn in ssis after completing the tutorial ji?
Ji learn SQL +SSIS+ Power Bi . This should be your flow ji. Informatica is good. But SSIS makes perfect match for power bi. Watch this based on your experience Power BI Interview - Topics - What to Expect - Playlist: th-cam.com/play/PLjNd3r1KLjQtX-KTIk1_CjG5_3b5dxnGI.html
The best SSIS tutorial i have ever had. I have been looking for one like this for the last couple of years and finally i got it. Thank you.
You're very welcome!
You are really a life saver man :D Thank from buttom of the heart, god bless you Bro
Thank you , share it with friends.
You are really god to me brother...god should bless you
Thank you , Keep learning. Share this channel with your friends and colleagues.
Join the telegram group to clarify your doughts
Can you please share us the data you are using for explanation....
We don't maintain it.
You can practice with your own dataset
Hi Nag, Thanks for this info. Question, how can we distinct records before inserting to the destination table to make sure that there's no duplicate records? can we do that in data flow ? Thanks advance for the answer
I don't think any transformation in SSIS to return distinct values.
Workaround is using sort transformation to remove duplicate. Check box to remove rows with duplicate values.
This will have a performance impact.
Better use distinct from source or after loading into target with duplicate, use procedure in control flow tasks to remove duplicate.
Use views for upstream system
@@AnalyticswithNags Exactly what I'll do. Thank you again.
Nice explanation sir
Thanks and welcome
can we use sort transformation in union all
You can use sort In union all. But is not required.
@@AnalyticswithNags thank u nag
Anna PowerBI lo power query lo ETL transformations chestam kada Mari SSIS nerchukovadam nduku anna
Watch this video. Answer in this video.
KNOW WHY !!! Power BI alone NOT enough to get a JOB [ Most asked Question to US]
th-cam.com/video/CEZEwAocB9Q/w-d-xo.html
How to select the join type in merge join?
Learn the joins concept here. Then you will understand which join to use.
th-cam.com/video/fkb6YdZAaag/w-d-xo.html
@@AnalyticswithNags thanks ji..I have a doubt jii..I know powerbi..which etl tool will be better to learn..ssis or informatica ji..I am following your ssis tutorial..if ssis,what should I start learn in ssis after completing the tutorial ji?
Ji learn SQL +SSIS+ Power Bi . This should be your flow ji.
Informatica is good. But SSIS makes perfect match for power bi.
Watch this based on your experience
Power BI Interview - Topics - What to Expect - Playlist: th-cam.com/play/PLjNd3r1KLjQtX-KTIk1_CjG5_3b5dxnGI.html
@@AnalyticswithNags thanks jii...
where other 7 videos, or how many videos in ssis
All videos are ongoing...will upload once recording is done and will upload this week. Keep learning
@@AnalyticswithNags ok
Nags still how many vedios left
Total 25 Videos. Which will cover 80% of SSIS. After learning this you will have strong foundation on ETL. So you can explore advance topics.
sir please provide the databases
Watch first two videos in playlist , I have explained how you can download the database from internet