DSXchange

Test_SUMM_SMRMNMP_daily..Aggr_Sales: Row out of sequence At row 90601, link "DSLink94" Row out of sequence This is the error what i have recieved . Thats the only error i got in my log. If you need to use Sort stage, leave out the ORDER BY in your query. And what error msg you are refering...

HI, I never ran it outside datasage for all the records , i will try it and give you the timing.is there anyway that i can fine tune my sql. Also as Ray mentiones i tried the option earlier but as i am giving two sets as unionall my query returns for example a b 1 2 3 4 a b 2 3 4 5 the above when it...

Guys, This is regarding the Aggregator problem and i have read previous posts on this , but my problem is i get a row out of sequence error from what i have understood in the previous posts this error will be coming when u are not sending the correct sort order for your aggregator , but i couldnt th...

Hi,

can I use an environment variable within the configuration file....

We can use parameter for config file. But I am not sure if we can use parameter for directory path of scratch disk

Can anyone confirm it and how to use parameters within it if we can

Thanks

Hi All, I am running a parallel job with a remove duplicate stage on a input source of 5 columns. I ended up with error saying not enough space. One of the column is varchar2(4000). If i calculate space needed with columns length as 4000 then the error is right, If i consider with the length of data...

Hi Do you have any other stage between transformer and lookup? Change the field names to something different and then try running it. hey, we use dto get the exact same error in my last project , tried different ways but ultimately ended in doing the same job as it is from scratch because it someth...

hi, you need to give the path where the error tables and the work tables and the log tables to be generated , also mention the session max, session min ,error limit , checkpoint e.t.c all these mentioned either in your stage or job properties as variables. you need to go to the report file to check ...

Hi Goriparthi, Websphere MQ series(IBM Software).This software is basically solution for application-to-application communications services regardless of where your applications or data resides. You can do a search in google else you can downlaod free trails of MQ series from IBM website and also t...

Hello All,

Could u please explain me what is WebsphereMQ.


Thanx in advance.

You can do this after doing a lookup, and sorting based on the data and using stage variables picking the lates and transforming. But if yo give with some example, it will be easy to follow up. e.g this is my source record date1 key id 06/10/06 abc 284 and this record will do a lookup on these reco...

assuming date2 for one rec is 10th and other record is 9th and you have date 1 as 8th. In this case you have 2 records greater than 8th. You can select the max(date2) to get the latest from them. HTH Can we do this in a lookup doing a lookup on one key (see in my scenario) and then when it get mult...

As said earliar, "date2" cannot be key. Avoid Hashed file. Lookup on "Key". You will get multiple match, have a constraint as "date2<=date1". Map the id in derivation. Hi, Can u guys say how to get the latest record in db2udb stage which satisfies the date2<=date1 cond...

Kumar, If date2 is given as key, then we don't have any column in source table to lookup in transformer. lookup functioning i need, 1) check the 'key' column 2) check if date2 < date1 3) If multiple records are found with step2 then get the record with latest date2 4) update ID in source record with...

Do lookup on the "key" and in constraint part, have your required condition "date2<= date1 ". And in derivation Map the "id" field. You can avoid hashed file. If you want you, you need to mark both "date2" as well as "key" fields as key. Where in yo...

Hi guys, i have a scenario in which i have to lookup multiple values e.g this is my source record date1 key id 06/10/06 abc 284 and this record will do a lookup on these records date2 key id 01/10/06 abc 123 05/04/06 abc 234 07/08/06 abc 345 08/22/06 abc 456 now do a lookup on abc and then i want to...