DSXchange

These codes or independent on Database you use, but the stage you use.

Reset the job, "From Previous run" log might give you more information.

Somehow the most of data is rushing in to Partition 0. What type of key is specified in Removeduplicate. What type data is it? If the data (key) is of same kind, hash partition will force to flow the data in same partition. Or try to partition on the key which is required for the removedulicate, on ...

There is no such 'material' for Datastage certification as other do. But you have lot of information provided in this site as well as in others. Check in IBM websit for the more information. Vincent has posted lots of blogs reg certification. Visit this post "How do I get certification for DataStage...

Concatinate as you specified, and have this funciton in oracle load stage.
to_date('10-MAR-2000','DD-MON-YYYY')

Hi Mohan,
There are many option available. Lookup will also be one kind. It all depends on your requirement. But for your straigt forward question, Ray has answered.
You can let us the requirement if it is different from what you expected.

By default you cannot have dd-mmm-yyyy as date format, unless specifed in the properties. So if input is 'Date' you can try the implicit conversion. Else you need to convert to a centrelised format and convert back to varchar with this format. Any how you will need to use these function.

Try to have a lookup table in the job design with the static informations, to avoid fuzzy.

I guess it should be something releated to your project (if at all you are working in), which might be discussed or told to you.

Can you delete the other dulicate post create on the same topic by you, before any one reply to that.

Since the file is in Ebcidic formate, you canot use unix command readily. Check whether you can count the number of lines of the file using wc -l command. If it succeed, it proves the file has the end of line as new line character. So you can wipe out the first and last in unix command in the filter...

Add a unique synthetic key generated and have a combined key while loading in to Hash file.
As Craig suggested, use only the requried key on lookup.

What about, selecting all the three column as key while creating the hash file. Or what about not mentioning any key at all.

Have DCount() function in the constraint to count and reject or allow the record based on the number of delimeter '*' found.
In derivation,

It depends on how you configured the Sequence. If you had give the $PROJDEF in JobSequence, it gets the value from Project level setting. Since, JobSequence is the point where the whole parameter value is been passed, your assertion will be right. If by chance parameter doesnt match each other, the ...