DSXchange

Hi -

Can you provide syntax of how to get the Last compilation date of the job?

We can acheive through sequencer Looping activity

Try below

stringtodate(<<columnname>>,"%mmmm %dd,%yyyy")

Also How many columns are in your job is also matter here.

Why you are running on One node. If possible run with 8 node and see.

No. You Cannot implement using SCD stage. But you write update statement call the same in before command in source/Primary link.

Yes. Due to Length issue. By the way what is your character set in Target oracle??

Ok. Put record count is 0 and try

Did you check any other process is trying to update the same table?

Use lookup condition like ((main.key1=ref.key1) or (main.key2=ref.key2) or (main.key3=ref.key3))....

Put merge statement in before job subroitine under job properties.

You can use LastRowInGroup(%inputcol%) transformer fucntion. Input column is code.

You can do it with single XML input stage and use 30 output links(each link is having one XML chunk) and In metadata descritpion tab provide the correct path.

Use range lookup.

why dont you use below function in database level

replace('906 N. 23RD ￜ STREET','ￜ')