DSXchange

I didn't get any errors job is finishing without any warnings. But all the rows are passed to the reject link of oracle stage with sqlcode-1403. The target table datatypes are: COL1:decimal[38,10] not null COL2:char(25) Unicode not null COL3:varchar Unicode null COL4:timestamp microseconds not null ...

I'm loading a table with source as sequential file using upsert method. My job design is: sequential file --> transformer ---> oracle table. At source i have 3 columns say col1 int,col2 char,col3 varchar. At target i have 4 columns say col1 int,col2 char,col3 varchar,col4 timestamp. primary key: col...

Yes Ray you're absolutely correct, "I'm handling null from input eventhough it never occurs". The requirement is to map the input(non-nullable) column to the same output(nullable) column.My job was finished with warnings as "converting non-nullable to null". I want to avoid this ...

Hi,

I have source as database where the columns are not nullable.This i need to map to nullable columns.The job got executed with warnings as converting non nullable to null,even after using modify stage.
Can some one please help it out.

Thanks in Advance.

I am using Datastage 7.5 parallel edition.
Under parallel jo guide--> appendix B --> utility functions, only one function is present that's "GetEnvironment()".

Is it present in 8.0 edition?

Please help me out..

I am using Datastage 7.5 parallel edition.
Under parallel jo guide--> appendix B --> utility functions, only one function is present that's "GetEnvironment()".

Is it present in 8.0 edition?

Please help me out..

I serached for the NextSurrogateKey() function in "datastage help" and "datastage manuals", but i didn't get any information about it.
Can anyone please tell me the syntax or where can i find this function.

Any help will be appreciated..

I am a novice in Quality Stage.Could you please help in my understanding of the following.After the Standardization stage if we have any unhandled patterns we need to override them so that we standardize most of the data. If my understanding is correct, this needs manual intervention. Before loading...

How does the output of the Match Frequency stage aid in the Matching process. I understand that in undup match we use both the match Frequency stage output and standardised data as inputs to the unduplicate stage. How do we comprehend the output columns of Match Frequency stage.

Thanks.

HI all, when i run the job from oracle entraprise stage to oracle enter prisse stage inbetween using with transformer stage. when it was declared like in source stage method: table read autogeneration 11 colummns in table in oracle , but here it has declared in the stage just 5 columns. its giving t...

thanks ray..

Thanks ray for the reply. I'm having a reject link to the sequential file stage, i want to know why the data got rejected? So where this information is present in any Datastage tables or files and how can i access it? For e.g: The record got rejected due to invalid number, whether this information w...

I want to know where the information about the rejected data of the "Reject link" will get stored in the Datastage repository.
I mean which datastage tables this information is present and how can i access those tables?


Please provide inputs to this..

Any help is appreciated...

The job aborts with the following fatal error. RT_SC1222/OshExecuter.sh line25 :9987 Seqmentation fault (core dumped) $APT_ORCHHOME/bin/osh "$@" 2>&1 The job has run successfully previously. We do not see any issue in the code as this abort has come up after many successful previous ru...

Hi
At times when i try to log in to designer and use a particular project i get the following message

ACCESS DENIED: Project currently locked
The project is currently locked by administrator.Try again or see the Administrator

this message comes randomly at times.
please advise appropriately