DSXchange

Hi, I just started working on IIS 8. Until now I am under the impression that Plug-in stages are faster than ODBC stage. is that changed in IIS 8? My client is using ODBC connector/ODBC Enterprise even when they have Plug-in stages. Please let me know which is better. Also what's the new features in...

You can use any one. Sparse will be fine if you don't want to go through sorting before you use merge.

nsm.

You can use any one. Sparse will be fine if you don't want to go through sorting before you use merge.

nsm.

do you want to create for that instance of the file?? meaning the every time the job runs will create pk's from 1 to n.

yes..I meant hashed file. To use a database table you need to ask somebody to create a table and what I have seen is normally DBA team doesn't create tables for this purpose and the other way I could think of is what I have given. I know its not really updating the sequential file but solves the iss...

check with isnull() and then depends on ur logic either insert 'Nothing' or a default date.

For Varchar type columns in addition to checking isnull() also trim the column and do your logic of assigning a value.

the other way I can think of is write the flat file to a hash and update the hash and finally overwrite the sequential file with Hash file.

Thanks
nsm

Hi Ray, I have tried to do it from Designer everytime I tried to delete even a single job from one particular folder Designer hangs. When I do the deletion from other folders under the same project goes fine. Not sure why that's happening for that particular folder..Even same thing happens after sys...

All,

Is there a way to delete a Category with in DataStage from Admin or UV?

Thanks
nsm.

All,

I was doing an export and my Client went to no response mode for long time. So I closed the client and then tried to login again , Its not letting me in where as I can login into my Director Okay. Was not sure how to resolve the issue.

Thanks
nsm.

I see what you are saying the issue we have here is everybody uses the same user id.
I tried seeing In the director by job wise but its not showing anything.

nsm.

Thanks ArndW.

When I open explorer all I saw are "Active Sessions".
how do I find the dead sessions?

Thanks
nsm.

All, I tried to delete multiple jobs from a folder and datastage got hanged. I closed the designer and then opened and I couldn't open my jobs folder. Opened the director and tried to see if I can delete a job then I got an error saying "Failed to delete the job <jobname>. <jobname>: this folde...

Can you explain what a "receive Queue" is in DataStage?
do you mean an RTI job when you say "always on" DataSTage job?

Thanks
nsm.

Hi, I have read that for column type changes/null conversions using modify stage is better. I have done those in transformer and it worked fine. I wanted to find out from the performance point of you does doing in the transformer add any overhead?,if yes how big a difference is it when you have to c...