Search found 3 matches
- Thu Apr 17, 2008 1:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reference lookup error
- Replies: 1
- Views: 1170
reference lookup error
Hi all, I am trying to join two tables: one as a primary table and the second one as a reference table. This is the error message I am getting: Reference lookup generated 91991 rows. Only the last row was used. I tried the join on a different set of tables and a different set of columns. I always ge...
- Thu Apr 10, 2008 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to convert this string 'm/d/yyyy h:mi' to date?
- Replies: 7
- Views: 6195
How to convert this string 'm/d/yyyy h:mi' to date?
Hi, I have a csv file that needs to be loaded into a DB2 table. The csv file has a date field in this format: 'm/d/yyyy hh:mi". Some examples are: 4/1/2008 1:23 12/31/2008 23:52 10/31/2008 22:20 ..... etc The month field is not always 2-digit. The date field is not always 2-digit. The hour fiel...
- Fri Mar 28, 2008 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Set up of Websphere Datastage and Quality Stage Designer
- Replies: 2
- Views: 1548
Set up of Websphere Datastage and Quality Stage Designer
Hi there, I am 'brand new' to datastage. I have worked on a huge oracle database as a ETL developer and 'partly' DBA for 8yrs now. I am currently on a assignment to work on Datastage on a DB2 database - both Datastage and DB2 are new for me which the employer understands. The hiring manager liked my...