Can I unit test Informatica Powercentre workflows? EDIT: More specifically, can I mock sources and target and test the steps in between? Eg. If I have a workflow with a Oracle source and a text file
Is the following workflow possible with Informatica Powercenter? AS400 -> Xml(in memory) -> Oracle 10g stored procedure (pass xml as param)
After searching stackoverflow.com I found several questions asking how to remove duplicates, but none of them addressed speed.
For some reason my MDF file is 154gigs, however, I only loaded 7 gigs worth of data from flat files.Why is the MDF file so much larger than the actual source data?
I\'m looking into replacing a bunch of Python ETL scripts that perform a nightly / hourly data summary and statistics gathering on a massive amount of data.
I need to do a lot of processing on a table that has 26+ million rows: Determine correct size of each column based on said column\'s data
I need to be able to extract and transform data from a data source on a client machine and ship it off via a web service call to be loaded into our data store. I would love to be able leverage SSIS bu
In the next few weeks, my company will be engaging multiple vendors to establish a choice for a common global ETL tool - not necessarily one that can\'t be broken from, but just where our license inve
I\'ve tried reading the Wikipedia开发者_如何学运维 article for \"extract, transform, load\", but that just leaves me more confused...
Using SQL Server Integration Services (SSIS) to perform incremental data load, comparing a hash of to-be-imported and existing row data. I am using this:
加载中,请稍侯......