DSXchange

Hi everyone, I am facing a very strange problem and would be extremely grateful if any of you could help me with the solution. I have a query which performs actions like pivoting up, aggregating (and then merging with the same data set) and finally a join. The 2 tables involved contain 30 million (m...

Thanks !!

Oh and another question ! I was going to put a separate topic for it but then realized that this question falls under the same subject. Consider this join select A.*, B.*, C.*, D.* from A,B,C,D where A.p = B.q and B.q = C.r and C.s = D.t How do I perform this join using a transformer ? Since there c...

Chulett :lol: Utmost respect for you, first of all ! Your intelligence, depth of knowledge, rhetoric attitude and complete lack of modesty makes this an extremely fun forum :wink: Total respect for what you do, though :) Anyways, I did finally do the thing that you have suggested. However, I'm conce...

Hi everyone, I am a complete novice (introduced to the world of DataStage, rather ETL just a couple of months ago). I am stuck on a problem and will be glad if any of you could help me out with it. I have 4 tables and I want to perform a join on them in the following manner select a.<column list>, b...