DSXchange

Use

Shrey can you please post the algorithm, what actually you did and how you solved it ?

Welcome aboard.

What is the job log like in Director ? Does it start and never stops or it gets executed but none of the rows are passed ?

you can use :-

TO_DATE(char[,fmt])

So as Ray mentioned in "fmt" use the format you need for eg :

TO_DATE('25-JUN-1952 10:55 A.M.','DD-MON-YYYY HH:MI A.M.')

In Transformer use Timestamp as SQL type for this field.

In all the 3 statements I see you compiled it but did you re-run the job after compilation ? Or you just compiled them?

Please correct me if I am wrong but this could work :

Seqfile-----------TX1------------Temp_Table----------TX2-------Target_table


In Temp_table do insert and in Target_table do Delete existing rows WHERE temp_table.column1=target_table.column1 and temp_table.column2 != target_table.column2

you need to give a bit more info than this, like what is your actual query and what are the modifications you are doing ? Let us know.

Suppose its the 5th field then

write a before job subroutine :

awk ' length($5) > len { len=length($5) } END { print len } ' file

Another soln
you can write a before job subroutine script :

{ rm -f infile && awk '{ for (i=0;i<3; i++) { print $0 } }' > infile; } < infile

from TBL1 while you are selecting and writing custom SQL use "DISTINCT" and in where clause use "GROUP BY" then the key you are using for join.

As you are doing Left outer join its going to take all records of left table i.e TBL1 and only matching records from TBL2 based upon the key.

Instead as you want to do look up you can use TBL2 for lookup directly instead of hashed file, no need to join.

Thank you so much Ray. Cheers to ya.

I have a random question just came up in my mind. For eg. -Suppose I want to do UPSERT 2M rows in oracle table. -Now due to some reasons the job is aborted after processing 1M rows. -Either I can reset the job and run again or look for another option as 50% work is done. -I will go for another optio...

You are in the wrong section. Please post in Parallel Extender section.

Dont understand why you want to do that. What is the database , If you are using ODBC as native driver ?