DSXchange

Hi,

I am getting this error msg whenever I run a Job.

"
LoadDWItem..Trn_Process_Data: ORA-01653: unable to extend table FXDW.DW_ITEM by 8 in tablespace DWD "

Is it something related to the Database size or something else??

Cheers,

Victore

Hi One of our client came with this request of Tuning their Jobs. When I checked the Job, they we quite ok, but the Performance was very much affected while running the Jobs. The DBA had informed that they have four CPUs, but I dont know whether Datastage is configured to use all the available CPUs....

Hi, I have a requirement. I have to extract data from DB2 table which is largevarchar in DB2. the Maximum size of the field is 32K. The source data for this field is split into differect records and stored. When we extract the data, we have to concatenate them and store in a Hash File or Seq File fo...

Hi,

Thank you very much, I corrected the problem.

Cheers

Victor

Hi,

Can some one help me.
I get an error like this "Parameter marker text size exceeds allocated space".

My job takes XML data and load to a Table. I update Old or Insert New Records in the Table

Cheers,

Victor

Hi,

I have a routine to Drive the first and last Date of Financial Year.
This I need to call in a Batch Job Control. Can some one help me to do that Please ?

Cheers,

Victor

Hi,

I need to delete the data in the Staging source Table when the Job is Completed running. Is there any method to delete in the Job itself? can we do in the Plug ins or have to write a after job subroutine?

Cheers,

Victor

Yes kenneth,

You are right. I need to know about the tasks of a Datastage Developer
and Tasks of a Datastage Administrator

Cheers,

Victor

Hi,

Can some one tell where I can find a documentation for Roles and Resp of a Datastage Developer as well as Administrator.

Cheers,

Victor

Hi,

I have a job where I extract the Results and get the Max ID of the Target Table and add 1 to write to the Target. I have taken the MAx id and add 1 to my Job. But since the Target File is a Big file, i am not able to Get the max id. IS ther any way to get the max Id of the Target table?

Cheers

Hi,

I will be designing ETL for Fact & Dimension tables. Is there a document that I can refer when I need to Design ETL Jobs to handle Fact & Dim tables?

Cheers

Hi, I have a requirement to group on more than one field. Say for example I need to group on ID_INTERNAL then CD_FORM, YEAR_OF_ASSESSMENT. How to I prioritise them? My first grouping should be on ID_INTERNAL and then CD_FORM and finally YEAR_OF_ASSESSMENT. Is there any way to line up the Grouping? C...

Hi

One of my Job is locked. I have been trying to clear the lock by cleaning up the resources. even then I can't clear the lock. Is there any any or any special command to clear them in the OS itself?

Cheers

Hi, My Routine is like this. IF ((CD_FORM1 = 300 And YR_RECEIVED1 = CY) And (CD_FORM2 = 393 And DT_RECEIVED2 > DT) And (CD_FORM3 = 990 And DT_RECEIVED3 > DT)) OR ((CD_FORM1 = 300 And DT_RECEIVED1 > DT) And (CD_FORM2 = 393 And DT_RECEIVED2 > DT) And (CD_FORM3 = 990 And YR_RECEIVED3 = CY)) OR ((CD_FOR...

Hi, I have a routine which has multiple If statement like given below eg: If (condition1 and Condition2... ) OR (condition3... And condition4....) Then Ans = 'ZZZ' Else (condition5.... and Condition6....) When I put the conditions in a single line then my routine works. If I put them in multiple lin...