Key function
Posted: Mon Apr 05, 2004 9:23 am
Hi,
I need to do a lookup between a file and a Hash File on more fileds (6). If I use the standard technique, It's very long.
I know (but I don't remember) that DataStage have a function where I can concatenate all these fields in a new field (for my two files) and after in the transform, The lookup is faster.
Is anybody know this command?
Thank you for your help.
Pey
I need to do a lookup between a file and a Hash File on more fileds (6). If I use the standard technique, It's very long.
I know (but I don't remember) that DataStage have a function where I can concatenate all these fields in a new field (for my two files) and after in the transform, The lookup is faster.
Is anybody know this command?
Thank you for your help.
Pey