DSXchange

Thx for ur suggestioons.
I solved the issue..

Hi I am trying to load the data between two date ranges. I am using a jobs equence with multiple instances of the same job and different date ranges. I am using two job parameters known as "LastLoadDate" and "Load Date" in Job sequence and the original job desin. I am passing two...

I went already through thhe above information.
I have everything set

But still its giving that error

But the table exists and its getting populated even though teh job is getting aborted. This is driving me crazy

Hi

I am trying to load a huge data nearly 30 million records.
My Job is getting Aborted with DBMS.CODE=ORA-00942 as FATAL and a warning as
ORA-01003: no statement parsed

But in the Designer, the links show that theey are fetching the data and loading the data into table
Whta might be the cause?

Thanks for your ideas. I will start building them and get back in case I have any more doubts

Actually when is the log table to be populated and how? I mean after I run my main job or before. First I need to create a table and Populating Log table will be done in a separate job. Is this so? Coming to Error table, this table is used instead of reject file. Is this so? Please correct me if I a...

Thanks for the replies.
Its not an interview question. Actually I am trying to do some best practices for my project. So I thought of Error Tables and log tables..

Hi What is the difference between Error Table and Log Table. As far as I know, Error table should have the rows got rejected while writing into the database and Log table should have records of time the job ran (start time and end time). Please share any ideas of How and Where in the Job to build su...

My actual job design is

Narasimha, What is meant by it picks up only 500 rows initially for the result set.
Its actually returning me the entire data set of 1 million records within 2min of time.
I am unable to get that point.

Thanks For the reply

Its not taking a lot of time..Its taking around 2min for 1 million records

Hi I am trying to extract the data from Oracle SOurce. Initially I used Dynamic RDBMS stgae as source stage. It was pulling like 4 rows per sec. I changed the array size to 1000 from 1. But it was of no use. I took the query and ran it in Toad and checked the Explain Plan. Everything looks ok. The Q...

Thanks a lot..

There were few null values,
I used in source itself NVL now and now its working fine without Iconv and Oconv

I solved the above problem by using Trunc(Columnname,2) in the source itself. But now I am facing a DS Phantom error when I am trying to do the following: 1) I am trying to calculate the balance amount as: ICONV(ACCOUNT_DR,"MD2")-->STAGE VARAIBLE 1 ICONV(ACCOUT_CR,"MD2")-->STAGE ...