DSXchange

You can use a routine to read parameters from a file and pass it to the sequence. This is how we do it.

Hi (DS.7.5.2, Oracle 10g) I have a server job, and i was running it with very limited amount of data (10000 records). The job was running good last friday, but today morning when i ran it the job was very slow, less than 1 row per second. Also i was monitoring the job using the job monitor option av...

Hi jcthornton Thank you so much. Your suggestions were very useful. 1)What do you do with Update records? This really made me think. I will move the targte look up to the begining, so i will be pulling and processing only few data. Also we are going to add creationdate and updatedate to the source, ...

Hi I have a requirement, I need to create jobs to populate table (insert). here is the table detail. The source table has nearly 50 columns. and the target table is something like this, col1_pk, col2, col3_fk, col4_fk.... col59. I have indicated the primary key and foreign key with PK and FK. The ta...

try using, to_char(<column_name>, 'yyyy-mm-dd hh24:mi:ss') and make the data type as varchar 19 or 26.

Hi
did you try changing the execution mode to parallel.

try using upsert method. Insert/Update.

Hi I would like to know, if there is a way to pass a value from a table as parameter. For example we use sequence as the primary key so for the first time if the sequence is 1, 2, 3....100. Then the next time it should start from 101, 102, 103, ... etc. We have a surrogate_key table where we store t...

Hi All thank you so much.

i used to convert all the null values to 0 (used nvl function in the source) and now its fixed.
thanks you so much.

Yes. one of the column (decimal) has null values.

Hi I also tried to check the data type for all the columns listed in the "If" statement and everything is same (Decimal 12.2)

this is what i have in that: Pin%%V0S84P10.Column%%13 = ( IF Pin%%V0S84P1.Column%%31 = 'SENT7' THEN FIX(((Pin%%V0S84P1.Column%%14 + Pin%%V0S84P1.Column%%5 + Pin%%V0S84P1.Column%%7 + Pin%%V0S84P1.Column%%6) * -1), 4) ELSE IF Pin%%V0S84P1.Column%%31 = 'SENT8' THEN FIX((Pin%%V0S84P1.Column%%14 + Pin%%V...

Hi thanks for the reply, I check the file, (in line number 302). this indicates to column number 13, and we have a "If Then Else" statement for this column and all the systax seems to be correct i do not see any error message in this. The job worked fine today morning. but now its giving m...

Hi Im getting a warning message. It reads: DataStage Job 2205 Phantom 218 Program "JOB.213807619.DT.1483139043.TRANS2": Line 302, Improper data type. Attempting to Cleanup after ABORT raised in stage LoanStgBKLoanTransSENT..xfm_SENT_logic DataStage Phantom Aborting with @ABORT.CODE = 3 i t...

I still have this warning message, Can anybody help me fix this. I recently heard that there is an Environmental variable used to fix this warning message. If known can anybody share it with me. Thanks in advance.