ETL - Tips on ETL develoment

When we do the development of mappings, workflows, there are some good practice, I will continuely list them in the following days,

Tips on mapping development
1) We can set the type the transformation to reusable, if we want reuse it. set the checkbox named Make reusable checked status.




2)Mapplet is one objects group with a standardized set of transformation logic. if some are used in your mapping, you can expand them in the Mapping Designer, so you can see all the objects(transformations) here, but need not open the mapplet in the mapplet designer.Click Mappings > Expand from the main menu. This expands the mapplet within the mapping for view. NOTE: but you cannot edit any of the properties.


3)one property of target table: Reject truncated and overflow data. (need to test to track it);
4)one property of target table: Table name prefix. (Need to test if it wants to format the table name like cmst.tablename).