shpd2852856的专栏

1)Severity               Timestamp         Node     Thread  Message Code  MessageFATAL   1/18/2011 17:50:51 PM  ETLDEVS1                                            *********** FATAL ERROR : Unexpe

1. write sql in mapping only, then refresh to workflow.2. be care of data type and length.3. naming convention and description standard4, check the result option when using the lookup transforma

Mapping 调优1) 尽量在source qualifier里过滤数据2) Join的时候，用数据量较少的表作为Master Table, 尽量用整型字段作为key来join3) 用aggregator, joiner的时候，如果能确认输入的数据已排过序, 可以打开sorted input. (Data must be sorted in the order of the 'gro