DSXchange

Can UniVerse evaluate such a query: SELECT A.BU_KEY,A.PERIOD_KEY,2 as UOM_KEY,CASE WHEN B.SUBS_VAL=0 THEN 0 ELSE (A.REV_VAL/B.SUBS_VAL*1000000) END AS ARPU_VAL FROM (SELECT BU_KEY,PERIOD_KEY,2 as UOM_KEY,SUM(REV_VAL) as REV_VAL FROM EISDWH.REVENUE_FACT WHERE REV_KEY in(167,170,172) AND IS_LATEST='1'...

Vincent,

This is exactly what I have done now. Thanks for the advice.
I had posted this query out of curiosity, if there is any way of synthesizing the dummy row in a Transformer Stage.

Thanks,
Siddharth

Craig, I did get your point earlier and as Ray pointed out, it is the constraint that is making the join inner. After some tweeking of the constraints I was able to get the row through and the transpose worked perfectly alright. But the question, the curiosity and the interest still remains :?: .......

Hello All, I have a situation where in I need a dummy row in my data set at the very end. I am getting this data set after a number of lookups, both database and hash. The actual problem as I have already highlighted in the forum is to transpose rows into columns and in order to successfully do that...

Hmm...
Craig, its not possible not to reject the rows as the volume is huge. So I will have to insert the dummy row somewhere in the "source" transformer itself.

Any insights how to do it?

Thanks,
Siddharth

Well I am open to try this out (I can do that on Monday only, when I get to the office) but I suppose that if I use the union to get that extra row in the dataset from the first table, the row would be rejected in the first lookup itself as the join has to be an inner join. I did wonder about this a...

I think you are going to need to expand on this just a little. :wink: I know how to setup a Transformer as a 'source' in a job, but I'd be interested in knowing what you are doing that requires both the source and the target to be Transformers and what's going on in the middle there. It will also h...

Okay, by doing some reordering of stage variables I am through with the above mentioned problem. But have run into another one. The last set of rows is not being processed. Reading the previous posts, I know the solution to this problem; i.e. adding a dummy last row to the source, but the problem is...

It's an easy pivot because you have exactly 7 rows and you can easily find the 7nth row to trigger the output. It gets a lot harder when you are pivoting an unknown number of rows, but that's another story...

I am greatly interested in this other story as of now....

Thanks,
Siddharth

The problem is that when the decision is taken that a particular group has ended, by that time the values associated with that group key also vanish. The offset is exactly by one. I am not getting any ideas to shoot off this offset.

Thanks,
Siddharth

Hi Ray, I had already done that search before posting this message. The closest I could get was this. http://www.dsxchange.com/viewtopic.php?t=85702&highlight=vertical+pivot&sid=f3472fca61db35fb81d5487cc107e5dd but this did not solve my problem as my input has variable number of rows for a p...

Hello All, I have this problem wherein I need to transpose a set of rows into columns thereby making multiple rows in the source to one single row in the target. My source in an Informix Table and I am using the Informix CLI plugin to get the data out of Informix DB. My target has to be a hash file....

Hello Devashish, Can you please also tell us which all stages are you using? If you are using the ODBC stage, then you cannot parameterize it; you will just have to change the username and passwords for all the stages and recompile the jobs. In case of routines, you can write the username and passwo...

Hey Guys, Vincent, TJ, Ken and Ray. Thanks for your insights. Infact I agree with you guys. I have been telling all these points to the client since I was industed into the project a month ago. I have done 3 projects in DataStage and this is my fourth one; the previous three being in the Datawarehou...

Thanks again guys.... The reason the client is skeptical in using Routines is because the application that is being built is a Data Migration application which will be replicated across the globe for the users. The users would just be trained to start/stop the jobs from DataStage Director. So for th...