Search found 22 matches
- 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: 10002
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'...
- 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: 6205
- Tue Apr 06, 2004 2:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
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 :?: .......
- 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: 6205
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...
- Mon Apr 05, 2004 1:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
- Sat Apr 03, 2004 5:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
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...
- Sat Apr 03, 2004 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
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...
- Sat Apr 03, 2004 12:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
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...
- 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: 17214
- Fri Apr 02, 2004 10:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
- Fri Apr 02, 2004 10:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
- Fri Apr 02, 2004 4:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transposing rows to columns
- Replies: 16
- Views: 10712
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....
- 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: 2860
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...
- 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: 3952
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...
- 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: 3952
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...