Transformer Compare Function..

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mcs_giri
Participant
Posts: 14
Joined: Sat Sep 22, 2007 8:44 am
Location: chennai

Transformer Compare Function..

Post by mcs_giri »

Hi wats the use of justification( L or R) in the compare funtion under strings in the transformer stage?
GIRIDHARANJ
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

Does the help not clarify it for you? :-

"Use a right-justified comparison for numeric strings, use a left-justified comparison for text strings.

For mixed strings, take care. For example, a right-justified comparison of the strings AB100 and AB99 indicates that AB100 is greater than AB99 since 100 is greater than 99. But a right-justified comparison of the strings AC99 and AB100 indicates that AC99 is greater since C is greater than B."
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Post Reply