Build you data warehouse in just 4 easy steps :
1) Specify your problem statement.
2) Create Dimensional Model using Erwin.
3) Create ETL Jobs using Talend.
4) Slice and Dice your Fact table in Tableau and visualize with great effects.
For Talend Training, visit www.learntalendonline.com
its great prsentation. ca you share the question/PDF?
It s very cool can you give us code source and the job Talend ? we can practice so
Could any one please share how to create OLAP Database in oracle or in any other. Are we using the OLTP database servers to create "OLAP" data warehouse?
The real talent is to create right dimension and fact, which of course is not a part of this video. Rest everything can be done by 1 year fresher guy.
I am a data warehouse architect from past 14 years, I clicked on this video thinking it would be something new (by looking at the title).. but it is just a waste of time.
I am not going to dislike this video but I feel bad for people who are here to learn something but will end up seeing someone's personal project with no insight. I am even not sure it this is a part of adventure works or similar database.
Hi Bharath it was very helpful can i get your email_id and flatfiles that would be veryhelpful
Thanks for this nice tutorial but i think there is a mistake with your type scd 1. For the first time when inserting it's ok but what when you need to check if there are new values in stg tables to be loaded in dim table ?
Can u just share those flatfiles with us…
Very nice video
Thanks for your video.
But I still don't know how the DIM_TIME table is created. Can you give me more insight into this?
Why the fuck can't someone who speaks English make a video on how to do something.
And all this in less than 18 minutes!
This is really a good Tutorial. Can you please share Source files?
how can i subtract days from current date.?
Great, but since Erwin is not open source anymore, is there any alternative tool which supports that workflow in the same way?
This is a very good video, I want so to reproduce your job to improve myself.
Could you please send me sources file ?
Can you please give me sources data file and Talend jobs it will be great help
Hello Bharat … it’s really very good explanation. I want to create same example, Can you please give me sources data file and Talend jobs it will be great help
HDFS, Pig and Hive using Talend for ETL and Data Warehousing
Nice video and very informative but i have one doubt you have implemented SCD2 without using wizard toraclescd what condition you have used can you please explain me that….
New OTN article on Data Warehousing: https://community.oracle.com/docs/DOC-1009928
Bharat, this is an awesome video, very informative and helpful! Thank you very much!
A question: I always thought that modeling data in a sta schema is only beneficial when slicing it in a classical OLAP cube tool like SSAS. If you ended up using Tableau as the OLAP tool, which basically join all the tables, wouldn't the performance (lets neglect for now the benefits of a warehouse and SCD2) be the same had you just loaded the source data to Tableau?
yes, that key is surrogate key..you can use any method to generate your key..either max of the key in table, or using sequence or using triggers..in this video, I am using max of key method to generate surrogate key
What is the surrogate key in the SCD type 2? The key changed from 1 to 967? is that because you defined the key data type as a sequence?