DSXchange

chulett wrote:Well, keep the technique in mind for those times when you can't do the aggregation in the source database - times where you are aggregating on transformed data, for instance.

Sure Craig,


Thanks

Raj

IF your source is a database, i would suggest doing the aggregation at the database level. Will be a bit faster. If not, then for sorting, do the sorting at the unix level, again will be a bit faster. IMHO. Regards, GUYS, Ya I got the job working , its only becoz i didnt supply sorted data to the a...

Make sure you sort the data in such a manner that supports the aggregation being done. Get it wrong and the stage will ignore your sort work and handle it itself. Also make sure you 'assert' the sort order correctly in the stage, get that wrong and the job will abort with a 'Row out of seqeunce' er...

thumsup9 wrote:I assume that you have sorted the data before aggregation

No, I didnt i am doing it now

Hi, i have a job in which data should be aggregated based on four coloumns dealer,invoice,year,month and take the sum of sales. i have 4.5 million records and job aborts around 1 million and only gives two warnings CopyOfCopyOfTest_MOP_RTLFDTC..Aggr_Sales: %s Abnormal termination of stage CopyOfCopy...

Guys,

Looks like its an issue with the indexes itself on one of the tables i am joining so DBA worked on it. I will let the schedule run once again and confirm the same.

I appreciate all the response from you guys

Thanks

Raj.

its actuallly extracting nothing almost .

we performed REORG AND RUNSTATS but we will do it again and i will update that.


Thanks

The Target Table ONLY CONTAINS I50,000 RECORDS , IT SHULDNT BE A PROBLEM


Thnaks again for ur replies guys.

Hi Thanks for your reply But we performed a reorg on the database and also performed runstats on the tables . But of no use. SELECT stage.I_DSTG_DIM, retail.I_RCUS_DIM as I_CUST_DIM FROM #pUDB_DB2_schema#.#pUDB_DB2_Table01# stage, #pUDB_DB2_schema#.#pUDB_DB2_Table02# retail WHERE ( stage.I_CUST_DIM ...

Hi All, This is a production issue and we have a job which generally runs for 4 minutes , but its running for 9-10 hours now . nothing has changed , we did everything we can in the database side but of no use . all the other jobs other than this runs fine. This job just extrats data from a db2udb ta...

hi,


Thanks for your reply,

I tried it with the parameter enabled in both server and parallel job but it didnt work out . Is there any other work around for this.



Thanks
Goriparthi

Hi, we are using abap extract stage to extract data from sap r/3 and in one of the jobs , i have a "#" sign in my data and i cant extract that , i mean the # symbol gets dropped when i am writing it to a sequential file. Can any one of you guys help me out on this. Thanks Goriparthi.