DSXchange

Hello Everyone, I was able to load the DB with load option. I will shorthly mark the topic resolved :D , but was just curios to know something. Can we set the row commit interval when using load option? Beacause I can see a hell lot of information messages being written to the logs. A piece of this ...

Hi hello105,

Thanks for sharing that information. It did help. :D

I had not set the APT_ORACLE_LOAD_OPTIONS in my job, So the orcestrate was setting the two options to TRUE by default. by changing the options as you said in your post the job ran fine.

Andrw,

Actually there are before each row trigger being added (We were not aware of this ).

I suspect that this migt be causing the load issues

ArndW wrote:My first guess is that you have an invalid character in your table name. Can you cut-and-paste the name to this thread? ...

Andrw the table name is "evdf_aft_cpr_raw".

Do you find anything wrong in this name

The above score shows that you are running the job on a single node and also the operator is a combined operator of seq.file, transformer and seq. file. So I dont think ther's anything wrong with the above score. It will generate only 1 process in this case. And also i think that no of links do not ...

Hi all, I have a job which has source as sequential file and target as Oracle table. The job is pure data loading with some validations. The target table on Oracle has two indexes, Due to which my inserts are very very slow. There are about 1.5 millions records in the seq. file. The insert is causin...

Andrw,

I am using the following approach

1. Remove all the blank lines using
2. Get the line count now using wc -l
3. head (above result -1) records.

Can I use multiple filters, pipe seperated in external filter stage?

Andrw, But in that case it will throw a warning in the log, saying import unsucessfull. And I dont want that to happen. Also on the reject link I have a transformer which will abort the job if a single reject is encountered (Its not evil, It's the requirement) 8) . So I have to avoid above two scena...

Hi Gurus, I have a flat file with some records and trailer records which will contain the records count. Below this count column I am getting a blank line and a EOF char at the next line as shown below col1,col2,col3\n 100\n ..............................................................................

You have source,which is a Database, Then why not restrict the record at source level if you are not interested in rest of the records?

Please help me here This question has been asked before. You can search for more details. However i will list out a few. 1) New Stages -> SCD stage and Connector Stage. 2) No Manager component available now, Designer has all the functionality of manager now. 3) New Designer Interface(WOW) -> The de...

Code: Select all

  63177716      1480        0  56745  37 RL  8791 evdfadm  evdf&!DS.ADMIN!& 

Hi Attu,

Thanks ofr that information, Can you tell me what &!DS>ADMIN!& indicate above

sheema wrote:If they want me to replace a Null for Col1 in source with ' ' than i should'nt be handling anything in the transformer right.

Yes thats right, :D But I think you should check with the business requirement

Sheema, Since you are replacing NULL with a ' ' @source. In Transformer you need to check for ' ' and apply the bussiness logic. If you want to populates nulls in the target stage, Then in transformer you can write this derivation, If lnk.inputcolumn = ' ' Then SetNull() Else lnk.inputcolumn. Now ma...

Ascii Value of NULL is 000

Ascii Value of Space is 032. If you are replacing the Nulls by ' ', Then IsNull() function will always be false I guess.