DSXchange

Two jobs would work. Please let me know how you plan to validate the count in first job.

Any suggestion if I had to do it in DataStage

I have a file with a No. of records and a control record (containing count of records) at the end. I would like to check that No. of records actually match the control record count, then only I will take the file for further processing. What will be the most efficient design for matching the counts....

I already have one started with 'ORCHESTRATE error ', but no one has responded to it yet.

No, it is not for interview. I am using 5 BASIC transformers in a parallel job (needs to call some server routines & macros not available in parallel transformer). The job fails with the error : node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (x40bdwas01): APT_PMPlayer...

Hi, I am facing the following job errors : node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (x40bdwas01): APT_PMPlayer::APT_PMPlayer: fork() failed, Resource temporarily unavailable node_node2: Fatal Error: Unable to start ORCHESTRATE process on node node2 (x40bdwas01): APT...

Please let me know the difference between parallel Transformer and BASIC Transformer in parallel job. Which one is useful under which scenario.

Thanks.

When we can have 'Delete' while using Change capture stage. If a record is deleted from 'Before' and it is not there 'After', that record simply doesn't get a place in output (which has 'after' and change code).

Thanks.

The file was created by some Legacy system and ftped to Datastage server.

The field lengths are all there in the definition.BILL_TYPE is of CHAR(4).Similarly I have all other CHAR fields with some lengths.

All the fields are CHAR fields only. Please tell me onething.I have my original Table definition (in the Table Definition\Sequential folder) different than this.Once I load the definition into the Sequential File stage I am making those modification.So, do I need to change the original Table definit...

I tried with the following :

Record delimiter string = \r\n
Record length = fixed
Final delimiter = none

Field delimiter = none

Then I get the following error :

Bad record delimiter after fixed-length record: expected "\r\n", got " \n"

Please advise.

I have trying to define a fixed width (length 89) file (each line terminated by DOS line) with the following options : Record delimiter string = DOS format Record length = fixed Final delimiter = end Field delimiter = none Field Quote = none I am getting the following error while trying to view data...

Actually I have a job that throws warnings (valid for now) and since the number of records is huge so it exceeds warning limit and gets aborted.This job is being called from within a Sequence.So, if I uncheck that option then the sequence will run and the job will not get aborted due to warnings.Is ...

And If I want to suppress the warnings in the Sequence itself then is this the compilation option to do this :

Uncheck 'Log warnings after activities that finish with status other than OK' in Job property of the Sequence.