DSXchange

Hi All,
Please help me to find the diference between tw dates-I hv tried with some option mentioned in dsxchane nothing works out.

My requiremnt is to get number of days between two dates

Thanks in advance

Das

First,How do you define performance?Actually,it depends on various factors like hardware config,CPUs used,volume of source data,etc..Performance improvement is like an iteration process and get the best possible solution. -Transformer would be better than Filter due to various reasons Moreover,with...

gssr wrote:You can hit some tutorial white papers in your favorite search engine for this issue....

Okey..But i want to know something about from ral datastge gurus or spcific issues...

Hi All, Plese advice ,Which is best way to use the stage to get the optmum performance. 1-Currently I am using remove duplicate stage to remove the duplicate records,but i think using of sort stage is better to do the same operation.. Please suggest..Can I achieve any performance improvement out of ...

The job logic is as given below Case 1: Job1-Create hashed file from table of 60 million records (fetching around 45 million records based on condition ) Job2-Using the hashed file created from job for look up purpose Job1 is taking long time to create hashed file,running 400 rows/sec So I tried the...

Thanks...

With out lookup it is processing 3000 to 4000 records per sec

Hi I want to do a lookup with a table having 50 million records , with the source flat file having 45 millon records First i have implimented it trough a haded file ,the hashed file created out of the table - It was very slow Now I have implimented a direct orcale stage lookup-It is based on two key...

Please help... I have triggered a DS JOB FROM UNIX Using dsjob command, Job is finished with out any warnings after 13 hrs and the data is properly loaded to target,so director also shows the status "Finished OK" But in unix command prompt it is showing the following error meaage Error 810...

Yes, tediously, through Transformer stage stage variables. Why not specify "Don't sort, previously grouped" in the Sort stage - you can still generate the cluster key change column, at virtually no ... Thanks Ray.. Plase help me in the below senario. Job Design src-------------->sort1----...

ray.wurlod wrote:In a phrase, unsorted though grouped data. ...

The same, can we achieve with out clusterkeychange ?

I have a dobt why we need to go for ClusterKeyChange ,Does it possible by KeyChange .I have used key change in meny occations .Any body can explain the senariao in which we are going for ClusterKeyChange .and Whts the difference

Thanks in advance

Set the "Create Cluster Key Change Column" property in sort stage to true. This creates the output field "clusterKeyChange". The values in this field will be 1 for a record, and 0 for all its duplicate records. Using the filter stage you can get the duplicates in one link and un...

Ok, it can't find your files because you've entered the values wrong. The Folder pathname should just be "C:\xml" and then your Wildcard pattern should be "*.xml". Give that a shot. ... Thanks.I didnt get your comment exatly. Actually all my XML files are keeping at the loction ...

Hi Thanks for your help.I have gone through the link mentioned below and did exatlt wht they mentioned but still I am facing some more issues realted to xml stages. Following is my job design ,to convert XML Doc to SEQUNCILAL file, Folder stage------XML input-----SEQfile stage. Folder stage properti...

ArndW wrote:If the hashed file is being referenced, i.e. read-only with no updates, then by all means run in parallel. Each job referencing this file will have it's own memory copy if the file is designated "pre- ...

THANKS A LOT