Hi , Nice Video. Could you please do a video on implementation of scd2 type logic in the stored procedure?
@1112electronics
Жыл бұрын
Great video..thanks
@VCKLYTech
Жыл бұрын
Thank you too!
@shashankm2859
Жыл бұрын
That was a great video.. What if my table has 500 columns, my query will become too long? Is there any better way?
@jayaram6843
2 жыл бұрын
Nice.
@VCKLYTech
2 жыл бұрын
Thank you
@vishal-xf6ev
2 жыл бұрын
Hi Sir, Nice video , could you please show demo for SDC type 2 in Snowflake procedure ?
@VCKLYTech
2 жыл бұрын
Will do it. thank you.
@vishal-xf6ev
2 жыл бұрын
@@VCKLYTech Thanks Sir
@vishal-xf6ev
2 жыл бұрын
@@VCKLYTech In this video , we used $ column from stage but what if we are loading data from other source like oracle table ?
@VCKLYTech
2 жыл бұрын
@@vishal-xf6ev we can not load data from Oracle table directly into snowflake database. For this, either have to use any ETL/ELT tool or generate .csv files from oracle and place them into snowflake stages. Finally load that file using copy command.
@vishal-xf6ev
2 жыл бұрын
@@VCKLYTech ok Sir. how we can do SCD type 2 ,when source is snowflake database only which is different from current database where we have target tables ? Can you please show demo for this using snowflake procedure .
@simhapurichinnodu5656
Жыл бұрын
How can we schedule this script?
@reddyram1457
2 жыл бұрын
What is the snowflake system high end date bro like in td (9999-12-31), since when try to add + 1 to high end it's accepting it supposed to give error like date overflow
@VCKLYTech
2 жыл бұрын
Actual value is 2099-12-31 but its showing as 9999. I have to check on this and will get back to you.
@sidhusidhu564
2 жыл бұрын
Bro I am searching for job on snowflake...how can I get communication with you bro
@sankarb5978
2 жыл бұрын
How to move csv file into archive folder after loading data into snowflake db.
@VCKLYTech
2 жыл бұрын
We have to write program/logic by using power shell script/python etc and call them from one the etl/elt(matillion) once your snowflake copy command get completed .
@sankarb5978
2 жыл бұрын
@@VCKLYTech can u please make simple demo on this.
@santhoshsreshta
2 жыл бұрын
@@VCKLYTech can you please make videos on Matillion too.. would love to see them.
Пікірлер: 25