DSXchange

Just change the precision to 2 and try......

Thanks every one for your response..

I used COALESCE function to generate the sequence..

In the above mentioned issue: The target table contains compound primary key with two columns I and C. C is hardcoaded to 11536 and I is a Oracle sequence generator column(finapp_mig.socpartycontractrole.nextval). can i use the above function in datastage? I dont know how to handle this sequence in ...

Hello Everyone, I am trying to insert a record into the oracle database by using the Oracle Enterprise Stage, Options I am using in the stage: Writing mode : Upsert Upsert Mode: Userdefined update only Update Sql: Insert Statement It is rejecting. It is not even showing any warning while running. Pl...

Thanks every one..

Are the key columns indexed ? YES How many nodes the DataStage server is running on? 4 How many nodes the Database server is running on? Are there any filter conditions over the selected data? NO If your job is supposed to be running in Production, then what are the loads on the database and datast...

Apart from the above person is there any one who can answer to my question with information I provided ..

Note: all the tables resides on the same database
Any way thanks for answering that you can't answer to my question..

Each Table has nearly 80000 to 100000 records..

I used NVARCHAR with 27 length in DRS stage.. It worked!

I am also facing same problem could any one through some light on it plaese.

Hello Everyone :) , I am using the DRS Stage to extract the data from SQL SERVER 2008 and i am using the below select SQL statement in it: Select A.XX, B.YY From A Inner Join B on A.ZZ = B.ZZ and i am getting the below error: [datadirect] [ODBC lib] Fuction sequence error SQLNUMResultCols: Error ret...

You can use the CDC Transaction stage in an IBM InfoSphere DataStage job to read data that is captured by IBM InfoSphere Change Data Capture (InfoSphere CDC) and apply the change data to a target database. The CDC Transaction stage integrates the replication capabilities that are provided by InfoSph...

Franklin,

Thank You Much.


Yes we need files (copy) in DS server before transferring to MF, now I got an idea about FTP stages.

This is the first time I am working with FTP stage I will try with both (FTP Enterprise and FTP Plug in) stages as you suggested

I appreciate you help.

Hi, In our ETL job design we need to FTP the files from DataStage server to the Mainframe. Could any one can suggest me the best approch: 1: Use FTP stage 2: Use Unix Script If FTP stage is the answer i have 2 FTP stages in Datastage 7.5 Verssion, 1: FTP Plug in Stage 2: FTP Enterprise Stage Could a...

Thanks every one:)