DSXchange

Hello All, I have an Oracle table(X) which has 4 columns. Two lookupfiles are created from this table. For each lookupfile(i am using datasets),we are having user-defined queries with diffrent filter conditions. Ouestion:-Which is the good practice. 1.Fetching all the records from the table and dump...

Hi, Thanks for the response. Loading the data directly to the database from a dataset vs loading onto the copy stage and then to database any performance issues. My business requirement has future enhancements so i am keeping a copy stage.Kindly throw your inputs on this and also on my designing app...

Hi All, Thanks for the inputs.So i guess I am going on with the right approach Extract the data from table and dump it onto a dataset. Read the dataset and do Transformations and load it onto another dataset. Load the new inserts seprately. Load the updates separtely. Another doubt.How can i decide ...

Hello All, A clarification in designing jobs. 1.I am having a job which does the Extraction from a source table and does some transformations(separates the new records and updates) and does an insert(seprate link)and update(separate link) into the same table . My doubt is can i do insert and update ...

Hi All, We have datastage installed in hp-unix with two node configration file. When i am trying to save a job i am getting the following error message. Error while creating job Untitled5 Error on CREATE.FILE command (Creating file "RT_CONFIG1330" as Type 30.mkdbfile: error initializing fi...

Hi, Thank u for the reply.I have got it that its not going to be easy to get the jobnames from the exported file. I am going to create a routine which is going to get the jobnames from the file and going to run the jobs. In this case i needed a file which has the jobnames in the order i have sequenc...

Hi,

Thanks for the reply.I need to read it into a file or table.If i see the sequence jobcontrol there also they are not in order.

From jobcontrol how can read it to a file or table.

Regards,
Bala.

Hi, I have to take all the jobnames in the sequence in the order they have been sequenced. I am trying to do this by exporting the sequence as an XML and from the XML i am trying to get the jobnames. In the XML they are not in the order they have been sequenced. Why it is so or any other suggesions ...

Hi,

Can I do an Execption and Error Handling through Datastage.
I am planning to set some rules a table and based on the rules.Is it possible in datastage.

Regards,
Bala.

Hi Arndw,

TGT_ACC is the name of the job_activity in the sequence.

Regards,
Bala.

Hi, I am having 22 jobs in sequence.I am getting the following Error when i run the sequence. Error setting up internal communications (fifo \\.\pipe\FIT-RT_SC291-TGT_CL_ACC) Attempting to Cleanup after ABORT raised in stage TGT_CL_ACC. Note:- 1.Laptop-both client and Server installed on same machin...

Hi, I am getting the following Error when i try investigating a word. NV(608):9/9/2000 11:48:30 AM (MSG_vio.c:12; vio.c:1526) ERROR: Incomplete record read from file C:\Projects\WINNCRM\Data\CUSTOMER INV(608):9/9/2000 11:48:30 AM (MSG_vio.c:13; vio.c:1528) ERROR: len=462, BufCnt=249, BufSize=102400,...

Hi, My input date is 1052003(dmmyyyy).I am getting this field as a varchar field(length 7). I want to convert this into date field(yyyy-mm-dd) In transformer i am using the function StringToDate() I assume StringToDate() takes only the exact date format(ie if i get the input field as 01-05-2003 then...

Hi, I have loaded a field(Eg:-2006-07-21) into the Oracle(10g) table as To_date(Field)(I have inserted using an user defined query). In another job when i try reading it from the loaded table,I am having a problem if i specify that field as date and read it.If i use a timestamp datatype to that fiel...

Hi,

The problem is because of RCP.Check the schema of the daatsets using Dataset mangement utility.

Regards,
Bala.