by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Two bits of Information I picked up from our principal Informatica Architect. When I used these, it did really work wonders. Aggregators and joiners should have sorted input. The Sorter Transformation sorts rows more efficiently that the Aggregator...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence, Data Warehousing
Lately, we at XTIVIA have seen a marked uptick for interest in open source ETL tools. Each customer situation is unique, but I would like to propose a few factors that you should review before making the decision: Incumbent Tool Set: Decisions around your choice...
by XTIVIA | Jan 31, 2012 | Blog, Databases
I’ve done a fair bit of work implementing custom ETL solutions with SSIS concluding that the tool provides excellent “out-of-the-box” support for ETL as well as almost limitlessly extensibility with the Script component. If you have a need to bring data from...