Look up in Server Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
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.
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.
Pratik Mondal
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
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.
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.
Pratik Mondal
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
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.
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.
Pratik Mondal
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
As to your parallel job question, as Arnd noted it belongs in the forum for parallel jobs, not in this forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
Ray,
tomorrow i will update you regarding the ds version (px job) that i'm using.
Thanks for your prompt replies.
Thanks
Pratik.
tomorrow i will update you regarding the ds version (px job) that i'm using.
Thanks for your prompt replies.
Thanks
Pratik.
Pratik Mondal
-
- Participant
- Posts: 5
- Joined: Wed Jan 02, 2008 9:05 pm
- Location: Chennai
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
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.
Pls share your thoughts.
Thanks.
Pratik.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 9
- Joined: Mon Dec 31, 2007 2:50 am
- Location: kolkata
Look up in Server Job
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.
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.