DSXchange

CAN YOU EXPLAIN THE RUNTIME COLUMN PROPAGATION IN PARALLEL JOB?

is there any function available to validate the incoming date in the datastage Transformer stage?

How to create a XML file from XML OUTPUT STAGE?
Give some hints to create the XML file

In Sequence job have two job activity A and B, if the first job A aborts, sequence should countinue to run with the next job B. How do i implement using triggers?

I need to insert a Date ('31-dec-9999') into my oracle database which has a datatype as Date. How do i do it using Datastage?

I received an error when i executing the job " DSD.BCIOpenW call to SQLAllocStmt failed.BABUS_SCD2..TARGET_INSERT_TABLE.DSLink32: DSD.BCIOpenW call to SQLColAttributes(ID) failed.
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client]Invalid cursor state".

Can you give me the suggestion?

WHAT IS THE MAXIMUM VALUE FOR THE KEYMGTNEXTVALUE() FUNCTION IN THE DATASTAGE? WHEN I USED THAT FUNCTION FOR SEQUENCE NUMBER GENERATON THE JOBS KEEPS ON RUNNING, IT NEVER GET TERMINATED? CAN YOU GIVE ME THE SOLUTION?

hi,
I got a warning during the execution of a server job like " OCI has fetched truncated data".. What does it actually mean??

Can we have that surrogate key genertor function in server job mode?

We want to generate sequence for a set of records. What is the available function to generate a sequence number for a set of record in the datastage?

In datastage, How to implement the slowly change dimension type 2?

Kindly, post the example for Nested If-else in routine for server job

Do we have any equivalent function to Round() function in datastage?

Do we have any equivalent function to Round() function in datastage

Syntax for the Round() function in datastage Routine using Server job?