DSXchange

Hi, I am having a strange problem with nulls. I assigned my field Daily_Date (Char 10) in transformer to CurrentDate(). It is populating with current date in my output. I deployed it on to client environment, client is complaining that problem is Daily_Date field is showing some null values in some ...

Hi, My job design is, two sequencial files (source). Target is oracle database. In between i added the change capture stage to record changes. The output is given to filter stage, by using change_code in filter three outputs are given to three modify stages (update, insert, delete). All the three ar...

HI
Can any one explain the usage of orchestrate in this below syntax.

UPDATE
source1
SET
col1 = orchestrate.col1 , col2 = orchestrate.col2 , col3 = orchestrate.col3 , col4 = orchestrate.col4 , col5 = orchestrate.col5

battaliou wrote:Define your primary keys in the output columns of your filter stage.

Hi Battaliou,

The source files are sent by the client and there are no primary keys defined. Is there any way to solve the logic with out defining primary keys

Hi, My job design is, two sequencial files (source). Target is oracle database. In between i added the change capture stage to record changes. The output is given to filter stage, by using change_code in filter three outputs are given to three modify stages (update, insert, delete). All the three ar...