DSXchange

Hi- I am trying to load data into a Oracle table which is partioned by week. I choose Index mode as maintenance. And when I run the Job the data loads correctly but the job status is aborted. The error gives Oracle log file reference. And the log file does not show any errors. Any thoughts. Thanks

HI,

Anybody knows what the fallowing error is
main_program: ORCHESTRATE step execution terminating due to SIGINT


Thanks

Yes, That is what i am doing. I am taking the table count against view count

I don't think your guess is right because i am running this view from production.The batch cycle in the production for the dims and facts will be done in the morning only.

Hi, My problem is like this Actually iam loading view from one database to another database table. One of the views has more than a billion records. my source stage is ODBC and target is ORACLE stage. Though it has more than 1 billion records its reading only 138 million records and righting the sam...

laxmi_etl wrote:

narasimha wrote:

Code: Select all

Input: -12.98 
select to_char(-12.98, '00000000.00')  from dual
Output: -00000012.98

HTH

This query works when i use it directly.But I don't know how to use it in
Datastage.

Thanks

Any thoughts?

narasimha wrote:

Code: Select all

Input: -12.98 
select to_char(-12.98, '00000000.00')  from dual
Output: -00000012.98

HTH

This query works when i use it directly.But I don't know how to use it in
Datastage.

Thanks

Also not reported is the method you are using to convert the decimal numbers to strings. Are you using a Modify stage or a Transformer stage? Which function are you using? Are you qualifying that function (for example with "fix_zero" for DecimalToString() function)? I am using Transformer...

How does your input data look like, can you give a sample of the same? A B C D ----------------------------------------------------------------- 20040327 007000594628 001 0 20040403 002200674670 001 0 20040410 007600451562 001 1843.5 20040417 005600236480 001 -4.57 20040424 007301178585 001 0 20040...

What is the length that you are specifiying for that field? Also make it char and not varchar. The length of that field should be 12,2. And i tried with char but still it's giving the same output. I am looking for the most significat digit dropped and replaced with a negative. . I think I am failed...

laxmi_etl wrote:

DSguru2B wrote:What is the length that you are specifiying for that field? Also make it char and not varchar.

The length of that field should be 12,2.
And i tried with char but still it's giving the same output.

I am looking for the most significat digit dropped and replaced with a negative.

DSguru2B wrote:What is the length that you are specifiying for that field? Also make it char and not varchar.

The length of that field should be 12,2.
And i tried with char but still it's giving the same output.

Thanks Ray..

Hi- I have to read data from Oracle table and create to a fixed length text file. It works fine except a field which has decimal field. I used a transmformer to convert from decimal to varchar using function decimal to string. The length of the decimal field should (12,2). Required output: 000000000...

Thanks for your concern.

I selected Index mode as maintanence and disable constraints true for the write mode append.

It solved my problem.

Thanks