DSXchange

You can use DateToString() by specifying the format and again convert back the result to StringToTimestamp().

Can you be more specific on the requirement, what is the unique keya and when you generate the new row what are the other column values. These two values are constant values or its going to change for the records.

You want to do it in sql or in datastage. If in datastage means you can use the filter stage which accepts the same format as you are using in the example above.

May be the records are not matching with the oracle stages so all the records are getting rejected. If i am not wrong the reference link will display the matched record count. if there is no match so u are getting 0 in reference link. try monitoring the job from director or put a copy stage in betwe...

Use this function it will remove the leading zeros from the column TRIM(col1,'0',L)

Use the change key column property from the sort stage which tells whether the record is duplicate or not. 0 will be the unique record and 1 will indicate the duplicate record based on this value in the stage variable u can achieve it

Hi use the modified if condition if col1='' then if col2='' then 'col1 is empty and col2 is empty' else if col2 > 10 then 'col1 is empty and Col2 length is > 10' else '' else if col1 > 20 then if col2='' then 'Col1 length is > 20 and col2 is empty' else if col2 > 10 then 'Col1 length is > 20 and Col...

The other way you can work to create a generic job for CDC is using the two column export stage one for join keys and another for value keys. you need to use the schema file,which has to be passed in the column export stage. For you scenario you can create two schema files for joining keys and value...

You cant import the metadata for the format given above, it considers the rows as separate record, so if you have sample file then follow the steps which you have mentioned above to create the meatdata in datastage.

Export the folder as one dsx file, for example if you have some 20 jobs in one of the folder export complete folder as one dsx file and open that dsx in any notepad and use find and replace option to rename the job.