DSXchange

From what I can see, "NULLIF VNDR_ITEM_NBR = BLANKS" this kind of transformation will treat blank columns as NULL. This can explain why the second example columns is null. "PRESERVE BLANKS" only preserves the blanks which exist in the input columns, I am quite sure it will not pa...

The standard SQL syntax works:

SELECT @ID, SUBSTRING(FULL.TEXT FROM 1 FOR 2000), TIMESTAMP FROM RT_LOG217

The Original Query is: SELECT @ID, FULL.TEXT, TIMESTAMP FROM RT_LOG217, And my job got the following error: ETL_DS_JOB_LOG.SBL_ODS_CUSTOMER_ACCOUNT.tLoad.Uni_RT_LOGS_inp: DSD.BCIGetNext call to SQLFetch failed. SQL statement:SELECT @ID, FULL.TEXT, TIMESTAMP FROM RT_LOG217 SQLSTATE=S1000, DBMS.CODE=9...

A simple way (probably not a good way) is to put two input links to one TeraData OCI, something like: source1=>Transformer1=> TeraData OCI source2=>Transformer2=> Ray, Let me explain what I am trying to achive. 1. I have two sources. 2. I am trying to process these records in to a single target tabl...

talk2shaanc wrote:Ideally u shdnt be getting the problem if u have renamed the common columns...worth giving it a try..are the columns renamed in the input stage itself or intermediate stage? if its renamed in a intermediate stage, try disabling RCP

Sam, did you try the above?

Not sure if my approach works for PX. But I had more than 50 sever jobs with similiar logic. So I exported one job as a dsx/xml flat file as a sample file, then wrote a shell script to produce the other 49 and then imported them back to DataStage repository. Any text editor could be used to search, ...

Not sure if my approach work for PX. Hi Folks, I am currently investigating the possibility of generating OSH script (and whatever else is necessary for a job to run) as an alternative to building many (hundreds) of very similar ETL jobs through the GUI. I need to know what needs to be generated (eg...

No, I'm afraid it doesn't - at least not in the OCI stages. You are probably thinking of Transaction Grouping which does force it to 1. I agree. Otherwise, it's not possible to make all the updates/inserts as a single transaction in the OCI stage with the option Insert new row or update existing ro...

You are setting the transaction size to 1000 with the update action of "insert new or update existing"? Arent you getting any warning message that says, that the size is set to 1 ? No, this is not an issue. And I don't think setting the transaction size to 1 is good for performance? I got...

Thanks for all the replies. I was using Insert new rows or update existing rows , not quite sure what type of lock was used :oops: but seems it was an exclusive lock. The transaction size I specified was 1000, so it shouldn't run for such a long after stopping...I tried to wait for several hours but...

My job was updating an oracle 9i table, it run very slow and had taken a long time. So I stopped the running job in deirector. But as a result, the table was locked. I expected DataStage could commit or rollback the database transaction even when the job was stopped. Is it the case or is there anyth...