I need to some more thing
Does DataStage need Windows XP Professional?
Can it run on other Windows operating system?
Ragu
Search found 19 matches
- Wed May 10, 2006 4:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastge with windows operating system?
- Replies: 6
- Views: 5170
- Wed Feb 15, 2006 2:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Not able to find the Hash file as table in UV Stage
- Replies: 9
- Views: 5108
- Wed Feb 15, 2006 1:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Not able to find the Hash file as table in UV Stage
- Replies: 9
- Views: 5108
- Wed Feb 15, 2006 1:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Not able to find the Hash file as table in UV Stage
- Replies: 9
- Views: 5108
Thanks Naveen, i will try what you said If you choose this option, you must choose the name of the account from the Account name drop-down list box. This list box contains all the accounts defined under the Table Definitions > Hashed branch in the Repository. If the account you want is not listed, y...
- Wed Feb 15, 2006 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Not able to find the Hash file as table in UV Stage
- Replies: 9
- Views: 5108
Not able to find the Hash file as table in UV Stage
Hi, I went through the forum to get multirow lookup I loaded the Flat File to a Hash file Account is left blank and Directory path also left blank in Hash File stage File name ContactHsh In the next job, I used UV stage to get the data from this hashed file I used localuv as DSN I cant find the tabl...
- Wed Jan 11, 2006 1:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple tables loaded into single target table
- Replies: 5
- Views: 2855
Multiple tables loaded into single target table
Hi, Need some help with this requirement I have 3 oracle tables ( which has a sinlge pseudo key column meaning there can be duplicates) with raw data directly from Operational data 3 tables have different metadata and there is a single ID field which is suppose to be same in all the three tables the...
- Mon Dec 12, 2005 6:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: equivalent for Between function
- Replies: 8
- Views: 3024
- Mon Dec 12, 2005 12:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: equivalent for Between function
- Replies: 8
- Views: 3024
- Mon Dec 12, 2005 12:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: equivalent for Between function
- Replies: 8
- Views: 3024
- Mon Dec 12, 2005 11:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: equivalent for Between function
- Replies: 8
- Views: 3024
Thank for the response, The dates are in MDY format Fieldx = 01-19-2005 SV2 = 01-01-1997 Filedy = 07-31-2001 (SV1 >= Fieldx and SV1 <= Fieldy) I think this might be the problem I am using the right hand side values directly from the Hash file I am not storing it in a Stage Variable Does that make a ...
- Mon Dec 12, 2005 3:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem with lookup
- Replies: 2
- Views: 1221
problem with lookup
Hi everybody, I loaded a oracle table into a hashfile I am using this hashfile as lookup The reference link(hash file that i created in previous step) has all data(no nulls) I am using the same metadata for the hash file But the reject link has null for three columns Because of this all the data are...
- Mon Dec 12, 2005 3:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: equivalent for Between function
- Replies: 8
- Views: 3024
equivalent for Between function
Hi Everybody, I need the equivalent for date between '01-Jan-2004' and '31-jan-2005' I am trying to select data that fall between a particular date I used ICONV and OCONV to convert the dates to the required format I used this in the constraint stageVariable1 >= StageVariable2 AND stageVariable1 <= ...
- Sat Dec 03, 2005 8:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Limitations on Hash File
- Replies: 3
- Views: 1826
- Fri Dec 02, 2005 4:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Limitations on Hash File
- Replies: 3
- Views: 1826
Limitations on Hash File
Hello Everybody,
Is there a maximum file size for a Hash File?
If the data exceed the file size, how does it work?
Does it keep overwriting the old data?
Thanks
Ragu
Is there a maximum file size for a Hash File?
If the data exceed the file size, how does it work?
Does it keep overwriting the old data?
Thanks
Ragu
- Mon Nov 07, 2005 1:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-02292 integrity constraint violated
- Replies: 2
- Views: 2425
ORA-02292 integrity constraint violated
Hello Everybody, I have a parent table and a child table I need to truncate and load these two tables I have to process the parent table first But this violates the integrity constraint because of the parent/ child relation how do i implement delete cascade in this? Suggest me any other method to im...