Hi,
can anyone please let me know how to change the file dictionary in this case.
Thanks
Search found 44 matches
- Wed Aug 06, 2008 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Stage
- Replies: 5
- Views: 2761
- Tue Aug 05, 2008 8:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Stage
- Replies: 5
- Views: 2761
Hi, Yes my input data has already contain a decimal place container, Can you please explain me how to make this change , i loaded some data into the Hashed file from a DB2UDB table . Hashed file is created in the project directory , Then i imported the metadata from the table definitions using the u...
- Mon Aug 04, 2008 3:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Stage
- Replies: 5
- Views: 2761
Universe Stage
Hi all, I am trying to use a universe stage to do a range lookup , this is for small amount of data , what i did was i loaded the data into a hashed file and then i am accessing through a universe stage , i have a decimal value which is 11,4 in the hashed file ,but i changed it to numeric and the da...
- Thu May 24, 2007 3:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
Ray, I got it woking , i am able to pick up the value in the query now the only thing is the terminator. job ran 4 times loaded 4 records in a sample file everything is fine but the sequencer aborted after the fourth run saying Error calling DSSetParam(delimiter), code=-4 [ParamValue/Limitvalue is n...
- Thu May 24, 2007 2:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
Ray, Which of these should i use in the parameter for my query SELECT DISTINCT main.I_CURR FROM DLROB.SMRATRN main, (select i_curr, max(i_dlr_dim) i_dlr_dim from dlrob.smrdlrd group by i_curr having count (*) > 1 ) temp where main.i_curr = temp.i_curr and main.i_curr=#delimiter# in the source stage ...
- Thu May 24, 2007 8:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
Hi I tried doing this with the datastage job and for one delaer it took about two minutes to update every record for that dealer .But when i tried it with around 1500 delaers job is in pending remote request stage in the database and its taking time , as the users are querying on the transaction tab...
- Sat May 19, 2007 9:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
- Sat May 19, 2007 5:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
Yes Exactly i was asking the same thing if i can do the same thing because i have only 5000 distinct dealers i can extract all the distinct delaers from my fact table and also look uo with a file from dealer table with all the dealers and the max dealer dim for that dealer. Only thing i wanted to ch...
- Sat May 19, 2007 11:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Strategy
- Replies: 11
- Views: 5294
Update Strategy
Hi Guys, I have a requirement to update one of the keys in the fact table.its a part of combo key in the table. Now this key is a dimension key and this dimension table used to have a slowly changing dimension till last year . now it was taken out due to the business requirements. the deal is to fix...
- Wed Nov 22, 2006 9:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: odbc connection
- Replies: 1
- Views: 1333
odbc connection
hi all, I am using a odbc stage to access oracle database in one of my job. It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage. I checked the ODBC connections it is working fine. ...
- Wed Nov 22, 2006 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc connection
- Replies: 1
- Views: 1386
odbc connection
hi all, I am using a odbc stage to access oracle database in one of my job. It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage. I checked the ODBC connections it is working fine. ...
- Fri Nov 10, 2006 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar conversion
- Replies: 6
- Views: 3636
Re: varchar conversion
If I mention 4000 through out the process, at remove duplicate sorting is using scratch space for 4000 which we cannot afford So we left the length as empty throught out the job. Just in the oci stage for load, we specify it as 4000 length varchar. Hi all, We are using a column as varchar without sp...
- Fri Nov 10, 2006 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar conversion
- Replies: 6
- Views: 3636
- Thu Nov 09, 2006 6:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar conversion
- Replies: 6
- Views: 3636
- Thu Nov 09, 2006 6:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: varchar conversion
- Replies: 6
- Views: 3636
varchar conversion
Hi all, We are using a column as varchar without specifying any length. But while loading in the oracle table we specify as 4000 length in oci stage. Records with length more than 110 are going to reject link with a warning in log which specify a future chance of truncation. I tried using modify sta...