DSXchange

Hi All, I tried to retrieve the timestamp of the last run of the job via the following command $dsjob -jobinfo project job The command retrieved the following stats: Job Status : RUN OK (1) Job Controller : not available Job Start Time : Tue Aug 12 14:54:49 2008 Job Wave Number : 3 User Status : not...

Ray,

Thanks for your quick repsonse, Yes I do get this error while I try to run the job independently.

Hi all, I have a Parallel job to read data from a dataset perform transformations and load the same into a DB2 Table. However when I try to kick off the job from the DS Sequence I get the following error: main_program: Fatal Error: Transfer does not have this output interface as its destination. Mes...

Thanks OddJob! Your solution was a beauty.

Hi All, I have a job which uses the filter stage to impose conditions on specific column data. I had parameterized this condition and could test the same successfully when I ran the job in datastage. However while designing the sequence I had intended to pass the value by reading a file in UNIX whic...

Hi All,

I have been facing problems while trying to comple a DataStage Sequence.

The Error thrown to me is like this :

Error writing to /busapps/diwd/751/_lgi/CPLSMAP2/RT_BP75/JOB.776752753
(seq_AZ_XISOtoCompStkTX)

Any ideas as to what it means.

Thanks.

Ray,

Unfortunately the client for which I work is still on Ardent 4.5.1 Version. They have a process of parsing complex flat files and loading into a staging table in Oracle. From where data would be picked up and later loaded to other ODS tables.

Thanks
Aditya.

Kumar,

Thanks for the reply. Sorry abt being unclear while asking the question.

Actually there is only ONE STAGING TABLE. This table feeds data into SIX DIFFERENT TABLES.

Thanks
Aditya.

All, I have a staging table from which data would have to be loaded onto 6 different tables, only straight inserts. The six table have a few attributes common amoung them. I had 2 job designs in mind and I wanted your suggestions on the best strategy. Strategy 1 : One DS Job loading all the data int...

DS Gurus, I have a requirement where I have to log errors to a file, do a count reconciliation on the file and check whether the count on the error file is greater than say x% If the count is greater than x% then I will have to rollback all the inserts I have made to the target tables. Else I will h...

Kris,

The two tables which are being joined have the update timestamp fields.

When I try to bring records which have been either update or inserted in both those tables and then try to do a full outer join on those records some of the records might have empty values for the fields.

-- Aditya.

Kris,

Thanks for the reply:

The hashed file ABC which is used for the lookup is also the same hashed file which has to be fed with the incremental loads.

Thanks
Aditya.

All, I have the following job design: DB2 Stage ----------->IPC-------->SeqFile SeqFile---------------->Transfomer-------->HashedFile The DB2 Stage contains a user defined query of joining two tables. 10 million records are extracted and later hashed. While tyring to do incremental loads into the ha...

"SEARCH" the forum.

I know this had been answered before!

Srini,

Do you have the Peoplesoft E1 PACK available? If so I could illustrate the steps needed.

-- Aditya.