DSXchange

Hi,

CDC is giving output edits, even though there are no changes.

Database is oracle. Please advice on what could be the potential issue.

I did check the few posts in the forum, but they dint help much. Still trying to figure out.


Thanks.

Thanks Ray. Actually there is a Change data capture stage after the transformer stage, the link ordering was incorrect in that because of that I was facing the trim issue. This issue got resolved, but a new issue came up.

Thanks.

Hi, Below is what I am implemented in datastage COALESCE(trim(field),'-1') I am using If clause where I check for empty string and put -1 else trim the field. If I use TrimLeadingTrailing(NulltoValue(field,-1)) I am getting an error while compilation saying that a composite call is not allowed. Henc...

There is no pdf for sybase talking about enterprise stage, but in IBM knowledge center the enterprise stage does exist for 11.3. It would be great if you can confirm that the Sybase enterprise and other native stages for sybase are still present and can be used in 11.3 However, compared to Sybase en...

Hi,

What is the best connection for sybase database. Is it DRS connector or ODBC connector?


Thanks.

Hi,

11.3 version does not support mainframe job. What is the way to connect to mainframes using datastage 11.3

Thank you for the information.

I am not sure whether this was checked during installation or not. How do I know now, whether I have this enabled for this installation. Is there any place were I can check if Balanced optimization is enabled.



Thank you.

Hi,

When I open a parallel job in designer, the File -> Optimize option is not appearing.

This is DataStage 8.7. Do we need to install any patch for this.



Thanks.

Its a kind of an academic question which go this way... Can DataStage process all kinds of unstructured data available today. Can it be a replacement of Hadoop?





Thank you

Hi,

Can datastage read unstructured data? When i mean unstructured it means, tweets or facebook messages.My understanding is we can read them but we will not be able to process them. Can you confirm my understanding.





Thank you

I have a scenario where I want to know how the values are getting populated before sort stage and remove duplicates stage using debugger. Also for a combination of input values i want to check this. But the expression in the edit breakpoints section is not allowing "AND" to be used. Is the...

Found the issue by putting a peek stage as output to oracle connector stage and rejecting the records to peek stage. But I had to change the job and put peek stage. Thought if I put the breakpoint before the oracle connector stage and debug at abort would give me the record which is actually causing...

Can you let me know the oracle trace file path?



Thank you.

Thank you Ray. I have a scenario where the job is aborting at the target oracle connector stage while inserting into a table. The error which it is giving is ORA-00060: deadlock detected while waiting for resource. The OCI function OCIStmtExecute returned status -1. Error code: 24381, Error message:...

Hi,

We have the debugger in DataStage 8.7. Can it be a replacement for peek stage which we generally use.




Thanks,
Prasanna