DSXchange

Thanks Ray , I found a workaround by adding an execute command activity after UerVaractivity in which i just echoed my user variable timestamp1. I have check pointed this execute command activity. For Job1 and Job2 i have passed the output value from execute command for timestamp1 instead of passing...

My Maseter sequence design is as follows loopstart ---UerVaractivity--->Job1--->Seq1-->seq2--->job2 ---loopend Note: All the Jobs are Restartable on failure and are checkpointed. I will generate a timestamp1 variable using TimeDate() function in UerVaractivity and Pass it as parameter to Job1 & ...

Thanks Roland Melzer ,

Your suggestion to mask the quotes helped me resolve the issue.

I have parametrized the source SQL in oci stage and that is functioning properly when the SQL is having simple select statement , but when i have a where clause with in the source sql with string comparison like select abc, xyz from table1 where xyz='NEW' iam able to view the data from the job but w...

Thanks for your inputs. As Told by Chulett , my paln of Comparing last modified timestamps of Job Design and Last Modified Timestamp of executable did not hlp me. Comming to the question of Mode of promotion used, This particular project seems to be messed up as there were some inports done through ...

Use Compare(Arg1, Arg2) function , the function returns 0 if both the arguments are similar

[quote="chulett"]Welcome. :D Your [b]Key Expression[/b] would simply be the column EFFDT so that it is passed to the ODBC lookup, everything critical is setup there. I'd suggest you first let the ODBC stage generate the SQL so you can see the syntax and then modify it. It will produce SQL ...

Hi all, First of all thank u for this wonderful platform. I have a querry. I am using a transformer to lookup a column from odbc stage. I have a coumn EFFDT in the input data to the transformer , STARTDATE in lookup odbc and the condition for lookup EFFDT<STARTDATE. How can i implement this conditio...