DSXchange

Does DS uses 2 processors on the same machine ?

I have a win 2000 server with 2 processors on borad. Was just wondering when I run the jobs does DS server uses the second processor or not ?

that is right for the row number coming into the Transformer.

Can you post the syntax error for: Also, i tried to use linkname.REJECTED in the constraint for the second reject table link, but it seems this is not available in parallel jobs, though the manual says i can use it. I am getting a syntax error when i use it.. though I may not be able help U much ..

Do you need the row number or a number that has to be generated for Surrogate key which is unique every time you run this job and insert data into DW.

for the latter: keyMgtGetNextValue('<key>') shld be used.

and also this issue shld posted in Parallel Extender forum.

Are you sure about it? Did u try it in a Paralell job?

I don't have access to PX. but I assume that won't be the case even in Parallel jobs as it totally beats the concept of DS and DW..

I think u might be using DSBASIC transformer instead of regual Transformer. Check it once more

Gotcha ! .. now I know it !!

didn't do it in Win before

thanks everyone ...

Craig, Let me rephrase my question, since I got a better idea what I am looking for this morning. :lol: What is the name of actual driver file to make a connection to Oracle using OCI stage? Is it named as : 'SQORA32.dll' ? Did I make my-self clear this time atleast? :roll: thanks for ur patience.

Use your:

Sairam wrote:b)Write to a file and then call that file on the next job (read I/o DIsk operation)

this will be more handly in case the previous job fails/failed to set the Job Parameters for this job.

this is will give you flexibility of restartibility also.

Please don't post this kind of topics in this forum. This kind of question has been answered before. There is nothing like DS FAQ for interview. The interview is a process which is unique for every position and the requirement of the position. Your previous exp and knowledge in DS should help you in...

Or if you really need to know abt Stage Variables, which I assume you are trying to learn. Then, in the Transformer -> Properties, the first Button on the top menu left to Constraints is the 'Stage Properties' window and in that option you can define Stage variables and give them the default value a...

I was just asking what is the driver name would be used to connect from DS machine to Oracle. my versions are: Oracle 8i and DS 7.0, OS: Win 2000 Server. I am cofiguring new machine and creating DSN's(which I am doing for the first time on Windows). Is the actual file is named: 'SQORA32.dll' ? Sorry...

Thanks Ray I got it working.

Can someone give me the Oracle native driver name?

I have Oracle 8 client installed and I want to make Oracle native driver DSN to use on my machine.


thanks

No Teej. U didn't confuse me. That is a perfect answer, I am looking for. One last question(may be I think so :D What is the client GUI interface for PX ? Is it DataStage client Designer itself for developing the jobs and, Are DS Director, Manager also used here. I am assuming that DS Administrator ...