DSXchange

In the target i have the following fields customer_ID,cust_state,Record_eft_dt and current_recoard_indicator so if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator alre...

In the target i have the following fields customer_ID,cust_state,Record_eft_dt and current_recoard_indicator so if an update record comes then the fields Record_eft_dt should be with the updated date and the current_recoard_indicator should be "Y" here if the current_recoard_indicator alre...

Hi i have a job designed for scd2,in the target i have 2 tables historical and current table.My question is how to move records from current table to histotrical table my client wanted to do this weekly once.
Help would be appriciated a lot.

Hi i have source and target are in oracle,so i have to capture inserts,updates and delets from source and in target i have to load in different tables called current and history tables please help me how to capture them and load in to targets.

Hi,
I have the my sequential files /cm/dev/crp/etl/rtl/DDW/dsh/dataset" in this path so plase how to view files in this directory through Unix.
please let me know that.
Thanks,