DSXchange

Hi, We can achieve this by Change Capture stage. However we need to run the job as many groups as many times. Get all groups in a sequential file and put in loop activity and run the job. Target | v Source -->CDC-->Filter(copy/delete/insert)-->target Thanks Gnan

Hi, I am using below derivation for a column in transformer. If Right(DSLink2.PRODCUTID,2)='10' Or Right(DSLink2.PRODCUTID,2) ='30' Or Right(DSLink2.PRODCUTID,2)='50' Then 'GNAN9999' Else If Right(DSLink2.PRODCUTID,2)='20' Or Right(DSLink2.PRODCUTID,2) ='40' Or Right(DSLink2.PRODCUTID,2)='60' Then '...

In Transformer1 I splitted data into to two links as per the condition. and Now I need to do lookup on same tables ie.,Oracle2 and Oracle3 but different conditions to the two links after that I am doing some validations in Transformer2 and transformer3 with Lookup values. and then funneling those tw...

Hi, I have a requirement. Based on the input column value, I need to insert one record as a two records with different values in other respective columns by getting from lookup tables. My job flow is like below Oracle1--->Transformer1---------->Lookup1-----------------> Transformer2----- | ^ ^ ^ | |...

Hi, My Job design is DataSet to Transformer, Transformer to Oracle Stage. In Oracle Stage I am doing Truncate then Load. The job has aborted due to following error. "Describe failed because of a missing column for SOURCE" Even I dont have any column with SOURCE name. Can any one help on th...

My Job design flow is: Extract the records from Oracle table. Lookup the source records to DOM_DATA table where DOM='FIN'. If any records matches then update the record in DOM_DATA column FLAG to 'N'. and Insert the same record in DOM_DATA table with DOM column value 'RET'. If Unmatched then have to...

My Job design flow is: Extract the records from Oracle table. Lookup the source records to FINANCIAL records in FIN_DATA table. If any records matches then update the record in FIN_DATA column FLAG to 'N'. and Insert the same record in RET_DATA table with SRC column value 'RET'. If Unmatched then ha...

Need to create a PX job for the following requirement My source data is like COL1 COL2 AAA 1 AAB 2 AAC 3 AAD 4 ... . ... . ... . 10000+ RECORDS Required Target data should be like COL1 COL2 COL3 AAA 1 AAA-1,AAB-2,AAC-3,AAD-4,.........10000+ AAB 2 AAB-2,AAA-1,AAC-3,AAD-4,.........10000+ AAC 3 AAC-3,A...

I dont want to modify/add the stages in the job. This has to be solved by PX routine or Unix script(After Job Subroutine).

mspanda--> U r correct. But has to implement this command in unix script. Thank for ur reply.

Any Replies with PX routine or alternative of PX routine to achieve this??

I have a job like Oracle(Source) ---> Lookup ---> Join ---> Transformer ---> Oracle(Target) My requirement is i need get the input link record count and pass that count value into Oracle(target) table as Total_input_records. I have written routine in Server using Linkinfo. Its working fine. but in P...

Hi,

For the delete Oracle stage can not support the reject link. It will show the following message in output tab of oracle stage "The currently selected link is a reject output link. There are no properties that can be set for this type of link".

Hi,

Whatever data u r inserting into that target table is not matching with your table partition condition. Please go through your table creation DDL command or u can view in SQL Navigator --> ur server -->ur schema -->Tables -->choose ur table -->Table Partitions.

In Datastage u can, But u have to pass maximum value of last run to startvalue by manually. By Using the Oracle Sequences you can achieve this with out passing any params by manually. Just create a sequence in oracle and use it where u required. Ex: Insert in to table(empid,ename, sal) values (oracl...

When ur source having Null values then u should Nullhandle in transformer.