DMExpress Basics - Part1

Hi Friendz,

Recently I got a chance to work on DMExpress a Syncsort ETL tool. I would like to share few basics and as well as to see your inputs/experiences with this tool.

I would like to relate this ETL tool with Informatica ETL tool as I worked on this too. I would appreciate if you can do the same.

Types of tasks I worked with so far:

Copy Task - This is very similar to Expression Transformation in Informatica with which you can simply extract the data from a FlatFile/Relational..etc sources and load it into a target OR any intermediate file proprietary format of DMExoress. The same can be used to perform further transformations (like filter,aggregator..etc)  before loading into target.
It has many built in functions to perform calucalations/conversions..etc.

I will continue adding more details to this. And I welcome you all to share your experience/questions if any to help DMExpress user community.

Thanks,
Naresh