DSXchange

It has been more than 48 hours since i purchased premium membership
to dsxchange and my profile is not updated.

oracledba

please moderator approve access to premium membership so I can access premium content.

Also there is another reason this error could pop up. This happened to me.
When you have a field name in the source file that you forgot to include in the output columns list then the exact same error pops up.

any other suggestions anybody????

Here is a peculiar error. In a datastage server job, My source data from a sequential file has date field with following value yyyymmdd Date 20121017 I am loading into oracle DB however that column in the database shows up as '21-JUN-57' (This is 06/21/7057) I am not doing any transformations on the...

i want all rows to be returned when duplicates are present during lookup

if you want to allow duplicates can you use another stage?

IBMDS4KK wrote:The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file.

Dont right click..... Double click on hash file stage. go to output tab. click on view data

so if i want all the records to come in is there some property i can enable to make it happen.

My Job design is, Oracle------>Transformer------>HashFile There are 100 records in source however only 50 records are loading into hash file. The performance statistics show 100 records loaded into hash file however only 50 records are there in the hash file. I checked the log and no warning or erro...

Some things to consider when doing Sever to Parallel job conversion -Datastage parallel jobs can run in parallel on multiple nodes. Server jobs do not run on multiple node. -Parallel jobs support partition parallelism(Round robin,Hash,modulus etc.), server jobs don't support this. -The transformer i...

if the oracle database has it as date then simply change it in the metadata definitions pull down for SQL Type and change to date. You have to make sure to use the data type that the source oracle database says it is.

StringToTimestamp(lnk_CONV.TS4,"%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS")



simply only include this

StringToTimestamp(lnk_CONV.TS4)

the extra fitting is causing the error.

not a bug. this is a legitimate warning I am going to assume the record name is DBUSER This mismatch is happening because your source database has the field DBUSER defined as decimal (38,10) and your target database has it defined as int64' . Whatever the reason may be there is a simple fix for this...

adams06 wrote:I cannot find the folder, By the way why we should edit that file only. Pls educate

You cannot find what folder? Tell me until which folder you are able to go to and I will help you from there.

I am asking you to look for a folder similar to that with numbers and letters

This mismatch is happening because your source oracle database has the field DBUSER defined as VARCHAR2(60) and your source oracle stage has it defined as VARCHAR2(20) . WHatever the reason may be there is a simple fix for this. Just cast it in as varchar 20 in your oracle query in source stage and ...