DSXchange

Does anyone know how to reover deleted jobs from Datastage repository.

Version : Datastage v8.1
Oracle 10g

chulett wrote:When it magically has 78 columns the next day, are the first 60 the same as the previous day? ...

Hi Chulett,

Yes, the first 60 columns are same as yesterdays

Hi Ray,
Can you please let me know how to create "missing columns" rules

Hi,

I have a csv file which can have 60 to 105 columns .
Eg.one day it will have 60 columns,next day it will have 78 columns and so on.

How should i load this file into Oracle database

Regards
Shadab

Use SAP Load Pack for loading data into SAP.

Hi, I am facing problem in loading data using DataStage Extraction Pack. I am using DataStage version 7.5.1A and BW pack 4.2.1. The Load Pack is working fine. In Extraction Pack properties, The InfoSpoke "xxxxxxxx" is appearing in the search, while trying to select the InfoSpoke the system...

I am using Change Data Capture Stage. I am comparing 2 Oracle table having 6 million records each.Both the Tables are identical. 2nd table is the copy of 1st table. I have not done any changes in the tables.However,I am getting 20,000 records as changed/updated.When actually there are no changes. Pa...

I also faced the same deadlock problem.
Making it sequential worked for me too.

Hi George,

Thanks for your input.

Please let me know how to make DATE_CACHE=0 in $APT_ORACLE_LOAD OPTIONS

I am Using Oracle Enterprise for loading the data.
It works as sqlloader in background.

How to increase the date cache and Errors allowed parameters in Datastage 7.5.1(PX)

Giving more details below I have one Date column in my Job.The input date value in the txt file is like 2007-12-31.I am using StringToDate function to convert this into date format.The input txt file has 6 million records. The Job gets aborted at 3 million throwing error as "Date conversion ca...

Hi,

I am loading 6 million records from sequential file to Oracle .
My Job gets aborted at 3 million.
The error message is "Date conversion cache disabled due to overflow (default size: 1000)".

Please let me know how to handle this .

Regards

Hi Ray,
Requesting you to elaborate more on using stage variables to achieve the above.

Thanks and Regards

I have input file with CSV file format as shown below H,1,2.... D,1.... D,2.... H,2,1... D,1... Record 1 says its the 1st header record with 2 detail records to follow. D1,D2 are its coresponding 2 detail records. Then 4th line is again a header record with 1 details record. I want the output as H,1...

kumar_s wrote:I guess you forgot to mark the post as mentioned. ...

Thanks for the info.. Marking it as resolved