DSXchange

In Datastage, we have two options of sorting, One is Link sorting and another is Explicit sort stage. Both methods will use the same tsort operator that means same scratch disk. So, explicit sort and link sort will utilise the same scratch disk for sorting purpose. Link sort is giving only few optui...

Hi,

First put your integer in a string field in a stage variable and convert that function into date by using StringToDate function as in the link suggested by Dsguru2B.

Bu default it is a Stable Sort that is performed. As kumar has mentioned set the partitioning to "Same" mode in the Join. If it is kept to Auto, DataStage will repartition the data (to HASH). If it is SAME then no repartition takes place, and the same sort order and the same partitioning ...

Hi, You have two datasets and one dataset you are using as a Driving one and another one is reference one. Is it right ? First check the data in the both datasets, whether any matching data is there or not ? Next check the Join type (Inner,Left Outer or Right Outer or Full Outer) and check these joi...

I am still confused ...

Y the RCP switch off and renaming columns is not giving the results to you ?

What is the status now ?

chulett wrote: First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

Yes, Its a Good Idea, first select the records and land in a dataset in JobA and then IN JobB trunacate those records. It will avoid you all of your problems regarding Truncation.

Hi Ajith, Here you are performing lookup and taking the field DESC from reference is it right ? If your lookup fails, it have to give Null in the filed DESC. Here my question is what is the nullability of filed DESC ( NO/YES). If it is NO, datastage will set ' ' for the DESC filed and check If it is...

This warnfing will come in two stages of PX. One is Lookup stage and another is in Transformer operator. If you change the Auto partition of lookup, you will get this warning.It is very meaningful warning for lookup stage and it is not meaningful warning for Transformer. Basically,Lookup stage inter...

Further to my previous post, please go through this link, it will give you more useful information about DecimalToString

viewtopic.php?t=92696&highlight=DecimalToString

and do believe in search option always. It is faster than humans.

Hi,

Perform This Function :

Trim(DecimalToString(Link1.CDML_AMT,"fix_zero,suppress_zero")) and make sure that your output field will be VARCHAR filed.

The Useful discussion ever I had read about Datastage logs by ray.wurold.

I am providing the same link here :

viewtopic.php?t=98926

Ramesh first search and then ask for anything in DSxchange.

Hi Ajith Thanks for your inputs. Actually my source is Sybase and the datatype for teh columns are smallint and decimal can you helo me what is the length i need to spacify in the metadata information. Thanks, girish Hi Girish, How he can help about your source fileds length of small int and decima...

What is your Target ? Is it a Dataset or Database ? Dataset Data is not visible means, is it showing dataset is not created in the mentioned path or it is simply showing dataser created but no data. that means empty dataset. are you able to view the data without these two options ? The path your pa...

What is your Target ?

Is it a Dataset or Database ?

Nagesh, do you mean to say that, if I include explicit sort stage, then DataStage won't use tsort operators? It does not make sense to me to use sort stage and then again tell the stage "Dont' sort". Hi Abhilash, You can do one thing to avoid one extra sort stage, perform HASH partition o...