![]() ![]() We then use a tMySqlRow component to pull the data for that particular building of the iteration with a prepared statement. We then iterate through every building, which allows us to keep just the records for that particular building in memory for the rest of the job. We start with grabbing a list of the buildings in the database using the following query in the tMySqlInput: "SELECT DISTINCT building The remaining 2 database components (the tMySqlInput and the tMySqlRow) then use the shared connection details. In this example job I'm using MySQL database components just because I happen to have a local MySQL database but everything about this job holds true for Oracle or MS SQL Server as well:Īt the very start we open a connection to the database using a tMySqlConnection component in this case. ![]() However, if you find yourself in a situation where you have a huge amount of data across a lot of buildings to the point where you can store any single building's rows worth of data in memory but not everything then I'd be inclined to use a slightly different approach. ![]() Gabriele's answer looks pretty good to me. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |