Thanks for your, reply can u walk through the steps...sudhakar_viswa wrote:Hi,
By using stage variables u can get this result.
Regards,
-- sudhakar
Search found 46 matches
- Fri Oct 19, 2007 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ranking system in Data stage
- Replies: 3
- Views: 1756
- Fri Oct 19, 2007 6:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ranking system in Data stage
- Replies: 3
- Views: 1756
Ranking system in Data stage
Hello Friends, I have a job similar to the ranking system in schools and colleges.. I am doing this job in Data stage and i am not getting the exact answer, for example St_name marks Joe 100 Tim 100 Jacob 50 Jason 20 The expected result, should be St_name marks rank Joe 100 1 Tim 100 1 Jacob 50 3 Ja...
- Fri Oct 19, 2007 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential:50 out of 200
- Replies: 8
- Views: 2048
- Fri Oct 19, 2007 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential:50 out of 200
- Replies: 8
- Views: 2048
- Tue Oct 16, 2007 9:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to load date into database
- Replies: 2
- Views: 698
HI
HI balu
whenever we try to load data into the database it will consider datatypes on his own so based on that we need to change or modify the datatype...
whenever we try to load data into the database it will consider datatypes on his own so based on that we need to change or modify the datatype...
- Tue Oct 16, 2007 8:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential:50 out of 200
- Replies: 8
- Views: 2048
hi
Thanks For ur reply, i tried with this but am not getting correctly..can you walk through the steps..ray.wurlod wrote:If it's in sequential mode use a Filter command that invokes the head command. Otherwise use a downstream Head stage. ...
- Sun Oct 14, 2007 9:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential:50 out of 200
- Replies: 8
- Views: 2048
sequential:50 out of 200
Hello Everybody,
I have a paticular job in that i need to send only first 50 rows of records out of 200 from the source plugin to the other plugins can any one tell a simplest way to do this...
I have a paticular job in that i need to send only first 50 rows of records out of 200 from the source plugin to the other plugins can any one tell a simplest way to do this...
- Sun Oct 14, 2007 9:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date format
- Replies: 1
- Views: 644
Hi pal, whenever we try to read any record of data from any database there will be a datatype mismatch in the date colum bcoz the database itself will maintain its own datatype for the sake of its conviniency the only way to change the datatype wud be using the identical datatype of the database or ...
- Sun Oct 14, 2007 8:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ACRONYM OF APT
- Replies: 3
- Views: 1412
ACRONYM OF APT
HI guyz wat is the Acronym of APT (Environmental variables)
- Fri Oct 12, 2007 12:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is difference between Hashed Files and Lookup Files set
- Replies: 4
- Views: 2828
Re: What is difference between Hashed Files and Lookup Files
hi
hashed file: this is used in server job. It does the function just like the Dataset in Parallel job.
LUKUPfileset: it is used in parallel jobs to enhance the performance.
i dont think these two has ever been compared...
hashed file: this is used in server job. It does the function just like the Dataset in Parallel job.
LUKUPfileset: it is used in parallel jobs to enhance the performance.
i dont think these two has ever been compared...
- Wed Oct 03, 2007 11:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup
- Replies: 4
- Views: 1989
- Wed Oct 03, 2007 11:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Apply
- Replies: 2
- Views: 940
- Fri Sep 28, 2007 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CHANGE CAPTURE & CHANGE APPLY- DATASTAGE
- Replies: 3
- Views: 1726
HI
YES i am an registerd user, do u have any suggesstions for my question...
- Wed Sep 26, 2007 10:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CHANGE CAPTURE & CHANGE APPLY- DATASTAGE
- Replies: 3
- Views: 1726
CHANGE CAPTURE & CHANGE APPLY- DATASTAGE
Hi guys i need a guidence from u, can u temme what is the need of base source in CHANGE APPLY stage and why we need to connect this. ![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
- Wed Sep 26, 2007 9:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATA STAGE
- Replies: 6
- Views: 2083
Re: DATA STAGE
mcs@rajesh wrote:hi guys ,
can any one tell me what is the difference between a dataset and a fileset and what is the need of using these two. And one more thing i wanna add up is what is the use of filter option in sequential file and when can we use it......