TX Map Performance Optimization

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
manojmmx
Participant
Posts: 8
Joined: Tue May 09, 2006 2:45 am
Location: Pune

TX Map Performance Optimization

Post by manojmmx »

Hi,

I am using TX8.0. I have a input Typetree with around 1000 data items and also there are many complex mapping rules. (like LOOKUP)
I am using TX Profiler utility to observe the map's performance. I fould following entries in the Profiler report.

Function Summary
function iterations time
-------- ---------- ----
VALIDATE_CARD 2 1688
BUILD_CARD 2 1763
TYPE_NAME 488 95
STRING_LITERAL 1959 186
FLOAT_CONSTANT 1371 175
ADD_OP 89 198
NONE 20 4
CURRENTDATE 2 2
IF 241 703
LOOKUP 8 288
MID 246 168
NUMBERTOTEXT 1 1
RIGHT_OP 22 14
ROUND 1 1
MAP_NAME 20 2062
LEFT_OP 3 1
TEXTTONUMBER 1 1
EITHER 8 293
FILLRIGHT 831 587
FILLLEFT 22 213
FROMDATETIME 2 3

Total 0.8446

If you see above data, the map takes around 0.8446 seconds to execute on my PC. What is this MAP_NAME function that is consuming most of the time ? Does anyone has suggestions/Tips&Tricks for improving the performance of the TX maps ?
Post Reply