DSXchange

harish_s_ampeo wrote:Wait for file is made not to checkpoint run.

why this is not with checkpoint? Any specific reason?
Try after changing it and post the results.

Regards,

chulett wrote: Nothing stopping you from resetting it from the Director first.

I apologize for not explaining it correctly but I just wanted to make sure the person uses the director to reset it.

Moderator Please move this topic to parallel forum.

Hi All, I want to know when an error/warning occurs while running the job. Director shows error like this: APT_CombinedOperatorController(1),1:.... So from this description how can we exactly identify were error has occured? Please use the search option first. Answer for this question is in too man...

Hi... It is not necessary to recompile the job, if it is failed.. Even if you reset the job , job can run. Compile is needed if you are doing any change to job.. hope this helps But all these things can be done through director only. From designer if a job is in aborted state it won't let you run w...

look for page no 48 and 49 of Designer Client Guide for more details.

Yes, It happens intermittently on systems on which users have restricted access. but closing and reopening the Designer client works most of the times. (in 8.0.1 Not sure about other versions.)

Regards,

heena wrote:Hi All

Actually I was working on lookUp stage and while looking for a column I am getting the following error:

Key expression cannot be set on key columns of this link .The connected stage defines the key lookup


Please solve my problem

are you using lookup fileset?

Please post the job design.

vinothkumar wrote:It may be in either Client or Server.

you can create a routine
to get the logs DSGetLogSummary() or DSGetLogDetails() can be used.
for getting the link counts use DSGetLinkInfo().

Or got to Kim Duke's site and see whether you can get something to fulfill your requirements.

It's a solution. I don't particularly like it, but it's a solution. ... Well this approach can give the desired result but what is in my mind currently i am writing the same 1. At the begining of the top sequence write 0 to a file or environment variable or some where else where it static during th...

If you would have elaborated the description of you requirement there might be some possiblity (workaround) for this requirement. Like looking up on immediate previous record or something like that.

but in this case Ray's comments says everything.

Hi Gurus, Sorry for hacking the thread, but I thought it would be easier for everyone to relate to my problem. I also have to find MAX of a timestamp variable. I used timetfromtimestamp function, as suggested, to calculate the MAX value in aggregator. My input timestamp field contains microseconds....

Thanks Miwinter, Furthermore, ensure you are extracting from your database in parallel if it is partitioned. It means I need to use parallel hint to fetch the records parallelism(rum multiple instance in db). Also I am using Sort atage to sort the data in Ascending order. If I use Normal lookup wil...

yes i need all records,for example in my source data empid =2 doesnot have a work phone so i need a output record with work_phone is null. but in my job design iam not able to capture those records in full outer join.can you please tell me is any other way to design he job. If yes then pass the rec...

So Which Country (Home or work) you are planning to put in country field (Output) if they can be different for same Emp ID. hi , please find my source data format MY SOURCE DATA IS EMPID,LOC,PHONE,COUNTRY 1,Home,1234,IND 2,Home,0345,IND 3,Work,0234,JAP 4,Work,1357,USA 1,Work,0012,IND 4,Home,5678,US...