DSXchange

1. I already tried with Forced Compile and it is not changing the status in the director. 2. I also tried with the "Multiple Job compile" option by compiling multiple jobs but no changes in the status. 3. Yes the status remain "not compiled" even after Ctrl-R. 4. When I try to ru...

Thanks for the Response, I did exactly the same as explained by you but the jobs are still showing as "Not Compiled" status in the director.

Hi, I am trying to compile some parallel jobs & sequencer jobs (Multi Instance Jobs) in my datastage environment wherein the designer is showing that the job is compiled successfully but when I check the same job in director it is showing as Not Compiled job. I would like to highlight one point ...

Thanks for the reply.
I ran the same sub-routine once again in the same project withou doing any changes and this time every thing was perfect, The jobnames which were having issues last time retrieved folder name correctly.


I am not sure what the issue is.

Hi, I have written a DS sub-routine to get the job wise Category/Folder name & writting into a sequential file. following is the query I am using for this purpose: SELECT JOBNO FMT '5L', NAME FMT '100L' AS JNAME,CATEGORY FMT '100L', JOBTYPE FMT '5L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; I trie...

One of my source table have some fields & i need to get hierarchical relationship beteen two of the columns. For example there are two fields in the table ID & SubID and they have relationships like ID SUB_ID OtherFields 101 102 ----- 102 103 ----- 103 104 ----- 104 105 ----- 105 105 ----- A...

I got it done done by having certain number of lookup (rejects link). I had input source & created required numbers of copies of reference data & matched in the respective lookup.

Hi Ray,

Thanks for the reply, the problem with LIKE operator is that data can have any pattern and i don`t know about the actual string.

Hi All, I am having some 1 millions of records(Source) having 4 fields and I have another reference table of 3 fields containing some 6-7K of records. The structure of Source table is something like: Field1, Field2, Field3, Field4 004960239674199,4921316782,SI025308,LNAZHADE 0034918382252,5939793841...

Thanks for reminding me the COPY stage.

I forgot to mention the number of records, the job is processing:

The input stream contains around 3-4 millions of data where as the lookup dataset contains around 0.1 million of data.

Hi, My requirment is to replicate the logic of oracle user defined function into datastage and my database is netezza which does not support these types of user defined functions. So for that i have prepared one parallel job for achieving the same thing with the help of DS job but because of the bus...

Hi All, I am having one server job which is reading csv file and writing into another temporary sequential file. This particular job normally used to take 15-20 min to do complete processing but since morning, When i am running the job it is continously in the running state. The job is generating wa...

Basically idea behind this requirment -> As this is monthly job, the data will be loaded into target table (appended) on monthly basis. So let`s say after loading this data, if there is any indication that the base ref data is somehow not perfectly correct so after getting the corrected ref data tab...

Yes, The changed values should be updated in the final target table also.