Loading fact table using talend

Hi,

In this blog we are going to see how to load fact table using talend .

• Drag an drop the source table and dimension tables. Connect the tables with tmap

visit the following link to know how to create the job and load the dimension table
http://easybisoln.blogspot.in/2016/06/loading-dimension-table-using-talend.html

• Double click on the tmap and map the fields

• Now connect the source id with the dimensions table id

• If you gave your id as automatic then connect the same columns  of the source and dimension tables

• Now give okay and execute the job . 

Your fact table has been successfully loaded. Do try this guys this is the simplest and easy way to load the fact table. Best of luck.

Regards,

Jerin P

Loading dimension table using talend

Hi,


In this blog we are going to see how to create a job and how to load a dimension table using talend.

• Open your talend 

• Create a new project

• Click on the create new job 

• Here i am going to load the data from excel to mysql , so go to metadata right click on the file excel and create file excel

• Browse the data source from the system and select the sheet which you want to use

• Set heading row as column name and refresh the view

• If you want to change the data type click on the column which you want to change the data type and change the data type

• To connect the MySQL data base refer my blog 

http://easybisoln.blogspot.in/2016/06/connecting-mysql-with-talend.html

• Drag the excel file and keep it as a input component, drag the tmap component from the pallete and finally drag the mysql table which you want to use and keep it as a output component

• Click on the tmap to map the source and the destination table.Click on the auto map it will automatically map the same field , if not drag and drop the field which you want to map and give ok.

• Click on the run to execute the job.

• Your job has been executed successfully , now open the mysql and select the dimension table to check the updated dimension table.

That's it you have loaded the dimension table using Talend. Hope this will be useful for you guys.. Best of luck guys :-)

Regards,

Jerin P

Connecting MySQL with talend

Hi,

In this blog we are going to see how to connect MySQL with talend hope it will be useful for you guys

• Create a job in talend go to metadata 
• Right click on the Db connection and select the Create connection

• Specify the name , purpose and description

• Select the Dbtype

• Select the Db version
• Login: Mysql workbench user name 
• Password: Mysql workbench password
• Server:The server on which your Mysql workbench has been connected
• Click on the check

 

• Go to the connected DB right click on that and select the retrieve schema

• Select the table which you want to use from the database

• Click on finish

That's it guys you have connected you mysql workbench with talend. Hope this blog will be useful for you guys. Best of luck.

Regards,

Jerin P

Connect MySQL workbench with google cloud sql

Hi,

In this blog we are going to see how to connect the MySQL workbench with google cloud.I have found a simple way to connect MySQL with Google cloud and i am here to share it with yo all. Hope you guys will find it easy.

• First sign in to google cloud plat form click on the console and create an instance

Select the generation

• Click on the advanced option

• Give the instance id and region
• select the Assign the ipv4 address to my cloud sql

• Click the add item in the authorized network ,browse your ip address and add the ip address

• Now the instance has been created
• Click on instance name
• Click on the access control

• Click on the user and create user account

• Now open the MySQL workbench and create connection
• Give the ipb4 address as the hostname
• User name: which you gave as a user name
• Password: Your password
• Click on the test connection

To get a static ipv4 address release the ipv4 address. You have to pay more for releasing your ipv4 address.

That's it you have connected your MySQL workbench with google cloud. Hope you guys try it. Best of luck.

Regards,

Jerin P

About Me

Hi guys,

I am Jerin . Formally educated as an engineer , now I am a technical analyst.
I completed my primary education with Holy Redeemers HRS in 2011 and received my degree in engineering from Karunya University in 2015 . Currently I am working as a Technical analyst at Foresee.

As i am a technical analyst i used to work with ETL tools and build Datawarehouse. And I found some simple way to work with ETL , Datawarehousing tool and Google cloud platform so I created this blog to share it with you. Hope it will be useful for you guys.


Regards,
Jerin P