Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-19 : 03:02:46
|
| hi experts,i'm not able to understand the difference between import/export and transformation.i worked on import and export. then what is this transformation? how to work with this?and one more thing what about ETL tools? E- extract, T- transformation and L- Load. i know up to this.how to start with these?please provide me guidence.i was allotted to work on DTS.i've to take care of everything.thanks for all valuble suggesions |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-19 : 03:20:10
|
| Extract (import or export, depends which side that does the job) is a method to be aware of information that resides outside of database.The information can be used to update current information or add new information to the database. In some cases, the outside information can be used to delete information in the database.In some cases, Transformation has to be done. This happens when the datatypes for the columns/fields does not match. Say you have CustomerID declared as INT in your database, but is declared VARCHAR in the outside information. Then you do a transform. Sometimes transformation is a bigger task, if the outside information is not normalized, but your database is.Loading is the final step, when using the outside data and merging it to the database.Peter LarssonHelsingborg, Sweden |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-19 : 03:24:14
|
| transform means to change. You may need to massage the data a little during an ETL operation before you load it into the final destination. maybe you need to alter the date format so SQL Server accepts it, or you need to concatenate two columns into one before the data load. Anyway, this kind fo thing is referred to as transforming the data. hence the 'T' in ETL.more information is in BOL. Here is another good article that gives you some basics and other references to read for more info http://en.wikipedia.org/wiki/Extract,_transform,_load-ec |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-19 : 05:55:29
|
| Thank you Mr. Peso and Mr eyechart for your good support |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-19 : 05:57:14
|
| You're welcome. Good luck!Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
transoframtion/export/import/load/extract