ETL
Can I unit test Informatica Powercentre workflows?
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[详细]
2023-01-14 14:31 分类：问答AS400 to Oracle 10g via xml with Informatica Powercenter
Is the following workflow possible with Informatica Powercenter? AS400 -> Xml(in memory) -> Oracle 10g stored procedure (pass xml as param)[详细]
2023-01-13 02:16 分类：问答Fastest technique to deleting duplicate data
After searching stackoverflow.com I found several questions asking how to remove duplicates, but none of them addressed speed.[详细]
2023-01-12 13:20 分类：问答MDF file size much larger than actual data
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?[详细]
2023-01-12 08:05 分类：问答Spring-Batch for a massive nightly / hourly Hive / MySQL data processing
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.[详细]
2023-01-12 06:32 分类：问答Best practice for operating on large amounts 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[详细]
2023-01-12 00:51 分类：问答Extracting Data Client Side
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[详细]
2023-01-10 23:12 分类：问答What is the required language knowledge to use Informatica effectively?
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[详细]
2023-01-10 15:17 分类：问答What is Extract/Transform/Load (ETL)?
I\'ve tried reading the Wikipedia开发者_如何学运维 article for \"extract, transform, load\", but that just leaves me more confused...[详细]
2023-01-10 11:21 分类：问答SQL Server Integration Services - Incremental data load hash comparison
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:[详细]
2023-01-09 06:55 分类：问答
加载中,请稍侯......