DSXchange

DSguru2B wrote:a big
Sorry, my earlier solution wont work. I overlooked the fact that your on PX.
Sorry.

thats ok, but is there some way to make it work?

Thanks

thanks for the reply ,

my column is in a dataset.
does that make it easy / difficult ???

i tried using nested conditions, but am not sure of how to provide a condition and that too based on a column that is in the resulting dataset of the previous job.

hello everyone, I need to give conditions in the jobs/ sequences in such a way that based on the conditions it will execute one of three job. This condition needs to be passed based on the value of one of the output columns of the previous job. We are using DS 7.1/ Can anyone help me with this. Than...

Thanks for all the answers..
as mentioned by Sud, I have give a value '0' and then in the later stages have used setnull ,, however i wanted to know if it could be done at the sql level to reduce the burden on the transformer stage.

Thnaks

hello everyone, I am facing a problem with an extract query that works well in the sql developer. the oracle extract query goes like this.. select a.clm1 null as clm2 (clm2 is decimal) null as clm3 (clm3 is char) from a this query runs well in the sql but when it is run in the oracle enterprise stag...

have tried using max and min for rest of the columns,, the job gets aborted .

yes, what you say makes full sense, and yes the other values have to be given a single value, lets say the last value. now how do I do that in the aggregator stage? using the max function in agg. stage doesnot help as they are char fields. I am not able to see any option like last / first in the agg...

yes , like Vinay mentioned my problem is different,, I have the columns sorted and it works well if i take only the grouping columns and the column to be summed. the aggregation is just fine... the problem is how to propogate the columns that are not a part of grouping key as well as need no agg. to...

Hello everybody, I am using 7.1 parallel aggregator stage. There are aaround 30 columns passing through it of which grouping needs to be done on 17 columns and '1' column needs to be summed up. however the rest of the columns (number as well as char) need to be passed just as it is taking first/last...

us1aslam1us wrote:why dont you do the lookup on id and use a transformer or modify stage for checking date condition.But i am not sure whether you will be able to do something in query.

Thanks
Sam

thanks for the help ,,, but if i use the method u are suggesting , are there chances or cartition product

hello,, I want to do a lookup on teradata table with data from dataset with the conditions -- when dataset.id = teraTable.id and dataset.date < TeraTable.date The first condition can be fulfilled using the key option ,,, but about the second condition of inequality .. how do i deal with it ,, is the...

Alternativly you can process the desired outcome in a job or routine and pass it as UserStatus to the Job Activity. Thanks for all the ideas.. so as you say i may not be able to use the basic functions as in 7.5... and as both of you suggested i could use a routine .... if I have a simple today - 3...

Hello I have worked on 7.5 px and there I have used the derivation in passing the parameter . it is just like a basic transformer . eg.... param for infile = <File Patern>||current date (it is done either at job level or seq level ...donot quite remember) and this value --- out come = ccd1.plc.0005....

Hello everyone,

I am suppose to calll a teradata macro in DS job and pass parameters to it ...
Is the teradata macro the same as the stored procedure ?
How does macro differ from a teradata bteq script.

Thanks for reading

DS1