Look up in Server Job

pratik.470 · Post by **pratik.470** » Mon Jan 07, 2008 12:56 am

Hi,

How can i perform look up operation in a server job as the look up stage is deactivated in my server job pallete.(os: Windows.DS 7.5)

If some one can advise..

Thanks
Pratik.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 07, 2008 1:23 am

Welcome aboard. Lookup stage only pertains in parallel jobs. In server jobs you use a Transformer stage to perform lookups.

pratik.470 · Post by **pratik.470** » Mon Jan 07, 2008 1:48 am

Ray,

Its absolute pleasure joining this forum.

If u can give me some clue regarding, if i wanna do the lookup stuff through transformer stage, what are the things(radio buttns to click/option to choose) that i must use in transformer stage.

An example would be a great help.

Thanks
Pratik.
Connectiva systems.

ArndW · Post by **ArndW** » Mon Jan 07, 2008 3:42 am

pratik,

there are so many options on how lookups are done in server jobs that no post could answer them. The best thing is to read the chapter on lookups in the server guide and if anything remains difficult to understand then you could post the questions here.

pratik.470 · Post by **pratik.470** » Mon Jan 07, 2008 4:20 am

Ray,

Thanks & I agree with you, lemme configure the same would come up in a day or two.

Mean while can you pls help me on configuring px job in windows.
I'm using
1.windows 2003 Server,Standard edition with .net installed for c++ compiler
2.Using DataStage 7.5
3.sample parallel job(Source :oracle table;transformation:Auto column match;Target:Oracle table)
4.error:the job is getting compiled but during validation showing'job type not configurable on this platform'
5.my guess the ds engine is unable to read the .apt file

can u send me some checklist/or kind of steps to configure parallel job on windows.also let me know wheather ds7.5 is compitable or not.

Thanks
Pratik.

ArndW · Post by **ArndW** » Mon Jan 07, 2008 4:29 am

Pratik,

a) This is a completely different question from the thread.
b) This is a PX/EE question, but this thread is in a Server forum
c) What exact version of DataStage on Windows do you have? There is only one version that will allow PX jobs to run, and from the error message it seem that you don't have it installed.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 07, 2008 4:48 am

Every input link you draw to a Transformer stage after the first is a reference input link; it will be drawn with a dashed line. A reference link requires you to provide a Key Expression in the Transformer stage; the value generated by this expression is sent to the stage on the other end of the reference input link and any row having that value as key is returned. If no row has that value as key then NULL is returned for every field mentioned on the reference input link.

As to your parallel job question, as Arnd noted it belongs in the forum for parallel jobs, not in this forum.

pratik.470 · Post by **pratik.470** » Mon Jan 07, 2008 5:06 am

Ray,

tomorrow i will update you regarding the ds version (px job) that i'm using.

Thanks for your prompt replies.

Thanks
Pratik.

chulett · Post by **chulett** » Mon Jan 07, 2008 7:45 am

And tomorrow we'll tell you that since you are not using 7.5x2 you can develop PX jobs on Windows but not run them.

APT.Minhajuddin · Post by **APT.Minhajuddin** » Mon Jan 07, 2008 9:10 am

Looks like the OP is obssessed with Ray

He sees Ray even when ArndW is answering

pratik.470 · Post by **pratik.470** » Tue Jan 08, 2008 12:11 am

Minhajuddin,

Thanks..man.Your eyes are compareable with that of 007 guy

ArndW: Thanks for your comments on lookup & px job.

Hope everything is now in sink :D

Thanks
Pratik.

chulett · Post by **chulett** » Tue Jan 08, 2008 7:02 am

You tell us. I thought you were going to post the exact version of DataStage you are running?

ps. 'Sink' is where dirty dishes go, you mean 'sync'.

pratik.470 · Post by **pratik.470** » Tue Jan 08, 2008 11:24 pm

Its datastage 7.5 Enterprise Edition/standalone machine with ds client & server installed with user count=1/as per release note parallel job can be configured in win2003server standard edition/while viewing data in source stage & during validation,'This job type is not currently runnable on this platform'-this error is coming.

Pls share your thoughts.

Thanks.
Pratik.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 08, 2008 11:50 pm

That is exactly because you have version 7.5, not version 7.5x2

Version 7.5x2 is the only version prior to version 8 that can run parallel jobs on any Windows platform.

Note that version 7.5x2 is not the same as version 7.5.2.

pratik.470 · Post by **pratik.470** » Wed Jan 09, 2008 12:22 am

From where can i get the exact version info from the application itself ? i checked all(ds administrator/manager/designer) from help>about; but not getting the info.

I think its Data Stage 7.5, is this the version just before that of ds 7.5x2?
During installation it asked for Enterprise Edition code so i guess its the Enterprise version.

As per release note also,parallel job can be compiled with this version in windows but to run the job Unix env is required.

So it seems parallel job on windows is not runuable with this version, infact i just wanted to make it clear to someone who actually demanded of doing it otherwise with 7.5.

Thanks
Pratik.