DSXchange

Hi, I need to create a datastage job based on below requirement. Source: SQL Server Target: Sequential File In Source there is a column with datatype XML, which holds the xml code in a single record as below: e.g. 1st record: <?xml version="1.0"?> <catalog> <book id="bk101"> <aut...

Thanks for the information. Actually I have found out that there is a field of type date in oracle but holds data in format '07/10/2004 09:56:20'; target SQL server has datatype timestamp Tried modifying the datatype in oracle stage from Timestamp(23,3) to Timestamp(19) also Varchar(23,3) But no cha...

The ETL Job is as below
Oracle (Oracle stage) --> Transformer (Where i map data from Nvarchar to Varchar & Number to integer fields) --> SQL server(ODBC stage)

Also data is not completely loaded in database.

DS version : 8.0
Build number : 1.2

Hi All, There is an ETl job to populate data from oracle (oracle enterprise stage) to Sql server (ODBC stage). The normal behaviour of an ETL job is to abort teh job in case of any fatal errors with status 'Aborted' and in case of any warnings with status 'Finished (see log)' The job now prompts wit...

Hi All, Can you please guide me with below issue: Below is the job populating data from Source: Oracle(Oracle Enterprise) to Target: SQL server(ODBC) In database the metatdata is Col1 : NVARCHAR2 (255) - > Col1 : VARCHAR (510) The jobs prompts with the below warning When checking operator: When bind...

Hi All, There is a sequence job which has multiple parallel jobs running in multiple series. There is an exception handler within the sequence to abort in case any of the parll job aborts. I have modified the trigger in parll jobs dng custom handling to execute the next parallel job only in case of ...

What diff will it make to start a new post all the relevant queries if are in same thread that creates any issues.

FYI as said by moderator try to search for an existing query rather than creating a new post.

Actually i am getting the warning after job execution and not while viewing the data in oracle stage
Also i am executing a select query whithout any constraints on a specific oracle table.
I executed the select query in oracle and then executed COMMit;
But no chng

What do you exactly mean by Just COMMIT to the execution query.
Please specify steps

Thank you all for your prompt replies, will informyou once i am able to resolve the above mentioned problm

The view 'vMain' is created not by any DS job but by an SQL query in Toad.

Are these option available in Datastage as in Toad i am getting the error while i execute the sql query

The query is very complex thus stating it in simplified format as below: 1.There is table named A1 which has columns of datatype number and varchar. From this table data is populated into a view vB1. 2. Similar way data from different tables (A1,A2....) is populated into different views(vB1,vB2...) ...

Oracle enterprise stage is used for extract.
Any other dtls reqd.


I know we can promote an information to warning but can we promote a warning to error. How?

No oracle enterprise stage

Hi, I recieve follwoing warning when i execute a DS job ORA-01722: invalid number There is a select query on an oracle view (oracle stage) to populate into a sequential file. An error is prompted when i execute the same select query through TOAD. I want the DS job to abort with the error "ORA-0...