What is the basic requirement while updating the perticular table using talend?
Answers
Answered by
0
ELT stands for Extract-Load-Transform and is an inversion of the data processing pattern "ETL". In ELT, data is manipulated within a database which is a huge performance improvement. Talend Open Studio comes with components like tELTMySqlMap to make the writing of such manipulations easier.
When updating data in a database, sometimes its easier to load a file in a staging table and then manipulate the data within the database. It may even be the only option based on performance requirements. Using a staging table means loading relatively unclean data from a source like a spreadsheet or CSV file into a schema based heavily on the input. Subsequent transformations and loads within the database will address the quality and move the data into a more usable format.
The Talend Open Studio (TOS) ELT components (for example, tELTMySqlMap and tELTOracle) will generate SQL INSERT OR UPDATE statements based on Talend metadata. While these statements can be formed by hand, forming the SQL with Talend will cut down on typing and errors. It's especially useful on a consulting job where large sets of unfamiliar columns need to be mapped
When updating data in a database, sometimes its easier to load a file in a staging table and then manipulate the data within the database. It may even be the only option based on performance requirements. Using a staging table means loading relatively unclean data from a source like a spreadsheet or CSV file into a schema based heavily on the input. Subsequent transformations and loads within the database will address the quality and move the data into a more usable format.
The Talend Open Studio (TOS) ELT components (for example, tELTMySqlMap and tELTOracle) will generate SQL INSERT OR UPDATE statements based on Talend metadata. While these statements can be formed by hand, forming the SQL with Talend will cut down on typing and errors. It's especially useful on a consulting job where large sets of unfamiliar columns need to be mapped
Similar questions