DSXchange

Hi Chulett,
I haven't started the coding yet. Just wanted to makesure that i implement all the best standards during the coding phase inorder to avoid perfomance issues while testing the object.

So i posted here for expert suggestions.

Hi All, I need to start coding for a job where it has 1 source and the source data needs to be looked up against 4 tables (say A,B,C,D). The source record count is 10 million+ records Lookup 1 (A) - 13000+ records Lookup 2 (B) - 15 million+ records Lookup 3 (C) - 500000+ records Lookup 4 (D) - 36 mi...

Hi all,
Please explain me logic on how to achieve the mentioned o/p as below.

COLA COLB
RAJ 3
ANI 5


o/p
COLA COLB
RAJ 1
RAJ 2
RAJ 3
ANI 1
ANI 2
ANI 3
ANI 4
ANI 5


Regards,
Balakrishna

If we'll be doing so then we'll miss the first set of values in each group (i.e 10,50).The output will be

A
20
30
40
B
60

A small correction in early post

On the output part of the transformer stage under the single column,the logic is

(If svcolA = prevscolA then prevscolB else COLA)


Regards,
Balakrishna

I tried the logic using the stage variables.PFB the details of the same.Initial values for these stage variables are null svcolA = COLA prevscolA = svcolA svcolB = COLB prevscolB = COLB On the output part of the transformer stage under the single column,i have written the logic as (If svcolA = prevs...

Saintah,
Will you please explain it in clear.I mean in which stage you were mentioning the change to be done.


Regards,
Balakrishna

Will you please explain me in detail.The o/p with the pivot will be A 10 A 20 A 30 . . B 50 B 60 . . Please explain me how i need to proceed after this. The output here should be in the exact format i.e (10,20,30,40) should exactly come under A and (50,60,70) should come next to B.This order should ...

Got the problem
There's no issue with the Change Capture stage.The query which i am using for testing purpose is giving both insert+update count and the same way the other is giving delete+update count.


Regards,
Balakrishna

Hi, I have a requirement where i need to merge the data coming under 2 columns into one.i.e say if i have 2 columns COLA COLB A 10 A 20 A 30 A 40 B 50 B 60 B 70 and the output should be presented in one column i.e COL A 10 20 30 40 B 50 60 70 Please help in achieving the logic. Regards, Balakrishna

Hi, I am having two Tables(Table_old) and (Table_new).I need to find out 1.records which are new(inserted) in Table_new, 2.records which are deleted from Table_new when compared to Table_old 3. records which are updated in Table_new. I've used CHANGE DATA CAPTURE stage and got the output as 57 - Ins...

Hi All, I am getting the same java error. I am working on Datastage Designer 8. I read in the posts to avoid the above error, set the class path and DS_HOME path like below DSHOME=C:\IBM\InformationServer\Server\DSEngine DATASTAGE_JRE=D:\IBM\InformationServer\ASBNode\apps DATASTAGE_JVM=jre\bin\j9vm ...

I have achieved this logic using Query in Oracle stage, Below are the details SELECT DISTINCT KEY, COLA, COLB, LEVEL AS LEV , TRIM( SUBSTR(txt,INSTR(txt,';',1,level)+1,INSTR(txt, ';', 1, level+1) - INSTR (txt, ';', 1, level) -1)) AS COLB_MODIFIED FROM ( SELECT KEY,TRIM(COLA) AS COLA,TRIM(COLB) AS CO...

Hi all, In one of my jobs i have a logic to be achieved which is explained below I/p COLA COLB COLC COLD COLE COLF 1 A1 B1 C3 D5 E7 2 A11 C12 F4 G34 H54;A12;C13 3 V1 X3 G2 S12 A12;E2;D67 i.e there might be multiple values present in the data which are seperated by special character ' ; '.I need to s...

Please neglect my earlier post.


Will any one explain me the logic defined in the above link mentioned.I didn't understand what they meant by using a particular code in Output Column Derivation