DSXchange

Can I SORT within the Change Data Capture stage itself?

Hi, I wanted to know if the SORT order changes due to partitioning? For e.g. if I have an Oracle Stage which has a SQL with an 'ORDER BY' clause, and then I send it to a COPY stage which has 'SAME' as its input partitioning, will the sorted data be maintained? Also, is it a pre-requisite to sort dat...

Yes we are specifying the invocation id and a dot along with the job name.

No it does not do that.

Hi, How do I get the ACCURATE record counts of links in a job? I am using the following command DSGetLinkInfo (handleJob, StgNmTrimed, LinkNmTrimed, DSJ.LINKROWCOUNT) in my basic routine. I would like to know if the same command can be applied for jobs which are multiinstanced. This is not working p...

I gave it in the derivation column within the Transformer.

I got the solution though.

This works: TimestampFromDateTime(StringToDate('9999-12-31',"%yyyy-%mm-%dd"), StringToTime('00:00:00',"%hh:%nn:%ss"))

Hi, I want to deafult a Timestamp field to ''12/31/9999 00:00:00" How would I do this in a Transformer stage? I tried: StringToTimestamp('12/31/9999 00:00:00',"mm/dd/yyyy hh:nn:ss") TimestampFromDateTime(StringToDate('12/31/9999',"mm/dd/yyyy"), StringToTime('00:00:00',"...

Hi,

How to subtract 1 Day from timestamp?

Thanks in advance.

Deepa

Hi,

How can we replace space character with new line character in UNIX based file?

For example, if "Dsxchange is helpful" is coming in a single column, I want the ouput in a Sequential File to be in the below format:
Dsxchange
is
helpful

Thanks in advance.
Deepa

In job 1, I am loading Table 1 to Table 2. In Table 2 all columns have been declared VARCHAR and all data is loaded successfully. In job 2, I am loading Table 3 from the same Table 2. Both have all columns declared as VARCHAR. In this job 2 its throwing this error of implicit conversion from ustring...

My Database is Oracle. The column is declared as VARCHAR2(50). But while importing metadata I have not declared as Unicode.

Hi, I am getting the following error: ODBC_PR_CUSTOMER: When checking operator: When binding output interface field "PARTY_NAME" to field "PARTY_NAME": Implicit conversion from source type "ustring[max=50]" to result type "string[max=255]": Converting ustring ...

Thanks Amey, will try this approach.

Hi All,

I would like to know how to increment the date column by a month using the Transformer Stage.

Thanks in advance.

Deepa

Hi All,

I would like to know the best Partitioning Technique for Change Capture Stage.

The preceeding stage is a Sequential File and the target is an ODBC Enterprise stage.

Thanks in advance.

Regards,

Deepa