DSXchange

Kcbland i am using the where clause but what is happening is the next stage is an OCI stage i do a truncate table before insert . So if the where clause is true that is the output of the first stage is 0 it outputs 0 rows but it also truncates the table i dont want that to happen if it does not load...

guys

thanks for your inputs i will try both and see

ridar : how do i store the check stage variable do i just pass the 0/1 into it and do a isnull(check)


let me know

thanks

rxs0005

hi all i have the below job oracle transformenr oracle the first stage has load date i need to put it to the next stage only if the sysdate is same as the loaddate if not dont load it. how do i do this i was thinking i will add a constraint but i cannot exit. or i can reject rows after i compare the...