Real Time Ecommerce project_1 from Capgemini client to load data into fact table

Here i am presenting complete project ,
loaded data from flat files to source tables.
source to staging tables by implementing incremental load with mapping variable,
then staging to dimension table by using SCD TYPE2,
then dim tables to fact table I loaded, I did this in two parts, please watch next part for final output

[@toxicans7777]

Thnqqq bro....excellent bro..big fan to u...

[@shilpakhirade6962]

Hey thank you for this video..can you please make one video on any health care project.

[@Ss_Ai_Infa_Tech]

Yeah i am trying for that...but currently i am in search of data related to Healthcare ...if u have send me I will do

[@irfanshariff7529]

Plz provide the data set files

[@nithmeth2292]

Bro, in interviews they are how we validate source flat file if everything is correct using Unix and and after mapping is completed how to check if everything is loaded properly. Can you please make a video on that or explain here

[@krishnaadabala169]

thankyou bro🤩🤩🤩

[@Ss_Ai_Infa_Tech]

Welcome 😊

[@anilkumarakc1046]

This project really Capgemini project or you are only created project

[@Ss_Ai_Infa_Tech]

cagemini project only i took reference from some other person.please ask any doubts on concept if u have any . Please avoid irrelevant questions which r not related to concept .

[@parthasarathimandal9437]

Brother there's no calls on Informatica. What to do with this skill set?

[@Ss_Ai_Infa_Tech]

Who told bro..I am still getting mails for interviews..next month I am going to attend...so I am revising..above 3.5 years experience required that's it

[@parthasarathimandal9437]

@@Ss_Ai_Infa_Tech I'm trying as 3.5 experienced. Either they are asking critical SQLs or they need someone who has experience on cloud. If I'm telling I have experience in PC, they're simply rejecting.

[@rajanib9057]

Hi,,,,,.when the ETL testing is done ?? ...is it during the source to stage load or when the data from the stage tables to fact tables are loaded ??

[@Ss_Ai_Infa_Tech]

After fact load