• I have worked with both SSIS and Talend Open Studio. One area where Talend speeds up development I would think is while building Fact table packages.

    In SSIS one would normally use the lookup transformation and you would get a split in your work stream for rows that succeed and rows that fail. For rows that fail you might want to provide some default values (unknown members, -1 etc.) using an Expression Transformation and then join both the streams back together using a Union transformation. Now in a fact package where you are looking up anything more than 15 or 20 dimension tables and the package size has exceeded 5MB - the entire package becomes unwieldy and a bit clunky i.e. takes a long time to open and close and make changes and save. This is because I think after every union - the variables flowing in are referenced as variables of the union transformation. Thus after every union transformation, this keeps on adding to the size. Also, from a source transformation, once can join to only one lookup at a time.

    In Talend Open Studio, there is the versatile T-Map transformation. How I wish SSIS had something like this! It is very versatile and in a single T-MAP transformation, you can pull in all the tables, the starting tables as well as the ones you want to lookup and then specify the joins and also provide default values. This makes development easier and also the job is still easy to handle.