DSXchange

Its working, thank you

Thank you very much! I used the below expression and the valid dates looks fine and I gave todays date for invalid dates. If IsValid('date',StringToDate(Out_Src.BRTH_DT,"%m/%d/%yyyy")) =1 then StringToDate(Out_Src.BRTH_DT,"%m/%d/%yyyy") else StringToDate('12/6/2012',"%m/%d/%...

Thank you Mike and Jwiles I gave the format StringToDate(Out_Src.BRTH_DT,"%m/%d/%yyyy") The birth date format I see in the output of sequential file is 7/4/2012, so I gave the above expression as per the document. I think the character warning went away but a differnt warning is seen Conve...

The expression I gave is StringToDate(Out_Src.BRTH_DT,"%mm/%dd/%yyyy") The warning which I see is Data string '4/2/2039' does not match format '%mm/%dd/%yyyy': the value for tag %mm has fewer characters than expected. The records in the target look like ******* for the date field Thank you!

Hello, My source data is like 7/5/2012 and I am trying to read it through sequential file where it complains that MM should be two digits there is only one digit for month. So I read the records as varchar in the sequential file and then used a transformer to change the data type from string to date...

Thanks for the input!


I will contact my admin to set these and run the ORCHADMIN.

We were trying to delete datasets from data set management in designer and our version is 8.5 As there are many number of datasets it is taking a while to delete them. Is there any other way to delete the data sets together other than orchadmin rm datasetname.ds as this throws an error which says co...

Go to the job properties of your sequence job and in the general tab

select the box which says:-Add check points so that sequence is restartable on failure.


Also just run it as it is with out compiling the sequence, this will start at job 4.

I have close to 50 jobs in a sequence job. If I run the sequence and the job 26 aborts the next 24 jobs are getting stopped. Is there any settings in the sequence job where If one job aborts leave that and go to the next job? So that next time when I run the sequence after fixing the job only that p...

Yes I am using sparse look up for which the parentkey
gets '0' in all the records.

and when I use normal look up the parentkey field is empty.

Second time I ran the same job with an other update link then all the records were updated with the right parent key.

Thank you

What I mean by dynamic is a row should be inserted and then lookup with the source so that the primary key assigned to the inserted row is used as a parentkey to other records. so that the table gets updated with the parentkey for all the records in the hierarchyexcept the top level. I set array siz...

Is dynamic look up possible in data stage 7.5 parallel jobs?

Made a search but could not find a scenario where dynamic look up is done in parallel jobs of 7.5 version.

please suggest any design to implement that in a parallel job?


Thank you

Thank you so do you mean do the lookup where it suceeds? actually this is a kind of dynamic lookup. The target needs to be loaded with an extra field which comes when we do lookup with the target itself. So records should be loaded and also look up has to be done as they get loaded and the records w...

I have a requirement to look up with the target as it gets loaded. i.e the records should get loaded in the target and then this should act as reference to the source to pull the key from target to update an other field in target. Now the job gets loaded with the empty field as their is no look up w...

Used drop for all the records where there is no lookup for the same field but still the records get rejected so that is not the case. In the target I used peekstage where I can see all the records but for some reason they are not loading into the oracle table(oracle enterprise stage). Please suggest...