DSXchange

As for the Program "DSLogInfo": Line 60, Variable "CallerName" previously undefined. Empty string used error, check the corresponding job, you must have something wrong with a call to DSLogInfo. Proper use should be: Call DSLogInfo (Message, CallingProgName) Check what you pass i...

Thanks a lot for your answer, Ray.
For once that it is lucky to be on Windows !

I would like to automate the deletion of the files in the &PH& folder. First I wanted to write a job which would execute a "CLEAR.FILE &PH&" and I would have run this job once a day, when every job is finished and before any other job starts. I have done this job and it wor...

Hi ! roy, what do you mean by the BB routine ? FYI I got an answer from DS support. They advise to use routines (even if you end up with a lot of them) rather than coding something that you could not have generated by simply using the GUI. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DS support a...

Ray, the answer to your question is yes. I have done the following: I have 2 routines with a link betwee. The parameter of the 2nd routine is the value returned by the first routine, concatenated to a string. It works in a routine activity. But it is not allowed (by the GUI) in a job activity. (At l...

Hi Ray, thanks for your time. Sorry for the late answer, this is due to having to leave for a long week-end (I am now in the UK and for this assignements I have got a 2 days and a half week-end, much better than India ...). I have had a look at the code generated and this let me thinks it is fine to...

Thanks for your replay Ray, Even if I know how to do what you suggest, most of the time I prefer to keep the original job sequencer because I prefer to keep the graphical advantage of the sequencer. I prefer to go for adding a routine to perform the calculation I need. Have a nice week-end. Where ar...

Hi there ! I have noticed a few strange behavior while building job sequence and would like to have some advice on the right use of routine and job activity parameters: 1/ in the job sequence, I have a job activity, for which I want to assign parameters coming from the result of a previous routine. ...

Hi there, I have been trying to find an efficient convention to store the metadata using DS designer and manager (stages, links and file name naming convention in the designer and convention related to the way of saving metadata from the designer or manager). When trying to make a few changes using ...

Hi there, I have been trying to find an efficient convention to store the metadata using DS designer and manager (stages, links and file name naming convention in the designer and convention related to the way of saving metadata from the designer or manager). When trying to make a few changes using ...

FYI problem just solved with the help of the support by doing the following: - kill the corresponding uvsh.exe process, either from the Windows Task Manager or with the kill command. To find the exacte program which corresponds to a process number you should use the Windows TLIST command - refresh t...

I just found the reason: the disk is full. I'll work on making some space, but what to do next with this job in an unstable state ? PS: I have found a huge file (name: DSD.RUN_35713_13036) in the &PH& of the project and I suspect this is linked with one job that is running since yesterday. I...

Kim,
Don't have to apologize, I did not take your answer in a bad way. It just maid me realize that my answer was more about Staging Points which so far I didn't really differentiate from Staging area. I'm happy having learned this!

Obviously my understanding of staging area can be improved ;o)
Can we consider that Hashed files, sequential files and temporary tables are the support of the staging area?
Can we say that the staging area is what we find between the Source Systems or ODS and the DW?
Thanks for your clarifications.

Hi ! I understand a "staging area" like a point and place within your ETL process that allows you to store a temporary "image" (most of the time it is done using sequential files) of your data set at that stage of the process (staging point). E.g. after extraction, before loading...