Search found 22 matches

by siddharthkaushik
Wed Jan 18, 2006 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: reconciliation of source data and target data
Replies: 13
Views: 9814

Sub Query execution in UniVerse

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'...
by siddharthkaushik
Tue Apr 06, 2004 2:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting Dummy Row at the end
Replies: 8
Views: 6124

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
by siddharthkaushik
Tue Apr 06, 2004 2:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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 :?: .......
by siddharthkaushik
Mon Apr 05, 2004 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting Dummy Row at the end
Replies: 8
Views: 6124

Inserting Dummy Row at the end

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...
by siddharthkaushik
Mon Apr 05, 2004 1:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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
by siddharthkaushik
Sat Apr 03, 2004 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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...
by siddharthkaushik
Sat Apr 03, 2004 11:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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...
by siddharthkaushik
Sat Apr 03, 2004 12:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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...
by siddharthkaushik
Fri Apr 02, 2004 10:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job to move Data in Vertical format to Horizontal Format
Replies: 17
Views: 17003

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
by siddharthkaushik
Fri Apr 02, 2004 10:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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
by siddharthkaushik
Fri Apr 02, 2004 10:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

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...
by siddharthkaushik
Fri Apr 02, 2004 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transposing rows to columns
Replies: 16
Views: 10419

Transposing rows to columns

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....
by siddharthkaushik
Wed Dec 17, 2003 2:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hard Code User Name and Password & Mail server
Replies: 7
Views: 2794

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...
by siddharthkaushik
Thu Dec 11, 2003 12:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of String as a Delimiter
Replies: 11
Views: 3869

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...
by siddharthkaushik
Wed Dec 10, 2003 4:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of String as a Delimiter
Replies: 11
Views: 3869

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...