DSXchange

Yes, i have tried to reset the job and run but i still get the same warning. The log job is as below : -Starting Job HL_Tbdwhapp20_Prop_H. raDbOraDSN = SFWHSE raDbOraUsername = sfdcetluser raDbOraPassword = ******** HshFilePath = /Data/SFDCUAT/hash/ -Environment variable settings: -HL_Tbdwhapp20_Pro...

I have a job that loads two columns from an OCI stage directly without any transformation into a hash file.The source tabel has around 2.8 million records.The job runs fine without any warnings in the DEV environment but it fails with a warning as below in UAT: Attempting to Cleanup after ABORT rais...

Hi Chulett, i used iconv along with left function to convert to internal format and OCI stage is taking this internal format and uses to_date function to convert to date. Thanks to all. There's nothing 'definite' about just using a varchar, there's more to it than that. :? Seya, what does your targe...

But i want it to be a date column in OCI stage and not varchar Ray i tried using Left (DSlink,9) but still is giving the below error st1..Transformer_16: At row 2865, link "DSLink4", while processing column "dtContractExpiration" Value treated as NULL Attempt to convert String va...

Hi, I am getting the below error while converting from timestamp to date. Source is SQL Server having date as time stamp. Target is Oracle having date. tst1..Transformer_16: At row 2852, link "DSLink4", while processing column "dtContractExpiration" Value treated as NULL Attempt ...

Hi, Could any one explain in detail how the following insert command work by using ORCHESTRATE.column name INSERT INTO #pOracleAuditSchema#.INBND_ADT_MV (SRC_SYS_CD, CP_DTA_STGNG_NM, SRC_BAT_PRCS_NO, BAT_PRCS_NO, SRC_BAT_PRCS_TS, SRC_DTA_FLE_NM, SRC_ENTY_NM, ) VALUES (ORCHESTRATE.SRC_SYS_CD, ORCHEST...

Hi All,


Can someone give more information on DSR STage

Thanks,
Seya

Hi Craig, Yes,I am trying to view data in a table after just loading. Yes it is for reference lookup. i have two OCI stage, First OCI stage i have loaded product information and i am able to view the data. Second OCI stage is reference lookup in which i have sales info(as shown below) .i have alread...

Hi, I am get error while loading data from oracle to OCI stage.The error is that after i load the table from oracle to OCI stage and try to do VIEW DATA it shows DATA SOURCE IS EMPTY. The oracle table which i have loaded into OCI stage has the following fields: PROD_ID DATE_ID VALUE ---------- -----...

Hi chulett, i did try what u suggested me but now i get this error iview1..Oracle_OCI_9i_0: Fully generated SQL is a required output link property. iview1..Oracle_OCI_9i_0.DSLink1: DSP.Open GCI $DSP.Open error -100. If you let the stage generate the SQL, you would never see this error. However, sinc...

Hi , when i try to view info from datastage after creating an oracle db in datastage and i did to load the table to the oracle db created in Datastage.When i do a right click to view (DS link6 data) it gives the below error iview1..Oracle_OCI_9i_0: Table Name is a required link property for Link DSL...

Hi,

I am interested to know about the ownership history of Datastage. Can anyone provide me information on this topic or provide me with some websites where i can get to know this information. i want to know if Datastage is called Ascential Datastage or IBM Websphere Datastage

Thank you

Hi,

I am interested to know about the ownership history of Datastage. Can anyone provide me information on this topic or provide me with some websites where i can get to know this information. i want to know if Datastage is called Ascential Datastage or IBM Websphere Datastage

Thank you