DSXchange

I think I explain bad. The scenario is as follows: I have a job that reads an XML file, this XML file is generated through the Job propierties < After subroutine instruction -> dsJobreport > of each job executed. With an independent job, I need to read the information from the XML file and take some...

Hello

I need to read the number of records that come from one source and verify that are inserted into a target.
source schema -> transform -> destination

to know how they recover and how many are rejected and all who successfully complete ..

any idea how to do this task

:D How can I validate the Datastage installation is ok, I mean after upgrade I need to verify all enviroment is in good shape, I ran a job and do some things to verify this and all of them were good, but exists any way to do this more strong?? How can I do that?


thanks for your support..

Hello I'm starting to work with XML Files, and I tried to load but I can't, I did something like this.. Server Job FOLDER Stage -> XML Input -> Secuential File Parallel Job External source -> XML Input -> Secuential file These two ways don't work for me, I don't know What I do wrong, configuracion e...

Hi. I'm trying to execute dsjob by SHELL SCRIPT, the job runs great, but return me an error.. IX1987.sh ERROR: Failed to open project Status code = -1010 DSJE_DOMAINLOGTOFAILED The code into the SHELL is #!/bin/sh export LD_LIBRARY_COMP=$LD_LIBRARY_COMP:/tcupappkg2_bin/InformationServer/Server/DSCom...

I understand what are you talking about, but, the question is, why transformation stage return this error when is compile??? I mean, All stages into the job should return error.. or??

I think so, I was executing some unix commands, as gcc, uname, the difference I found is in Development enviroment has Gcc compiler ver 4.1.3 Pre-production enviroment does not have compiler.... but, I'm confused, why when I promote Server jobs those jobs are compiling great but Parallel no.. Does i...

Hello.. Please, if somebody know what can I do to fix this issue thanks.... I have 12 Parallel Jobs into Development Enviroment and today I need promote to Pre-Production server to run test cases and whatever... The point is, when promote parallel jobs, and try compile all jobs are return an Error, ...

Thanks for everyone , Now they are working...

You mean, something like this..


ORACLE -> TRANSFORMER ->TRANSFORMER RULE 1 ->\
-> LINK COLLECTOR
->TRANSFORMER RULE 2 ->/




OR FUNNEL -> INSERT(ORACLE)

Hi EveryOne.. I need your help please, I try to validate one row two times, I mean.. Step 1 Select * From Table Where Campo1<> 0 And Campo2 <> 0 If the last step retrive one row like this campo1 campo2 1 2 Then, I need insert for this row 2 records in other table_insert previous validation with this...

Hi, I need validate a Field in Transformer Stage using a QUERY... like this.. A query before retrive some records, each one has 4 fields, I need validate field One with Query... select code from code_table where code_name = #select1.field1# if sql = true then ................. tan, tan... Thanks for...

Ok, Do you know how can I Validate a Field into transformer using Query..??

Hi Craig.. Well, I need to do this Stage.... 1.- Validate day > 0 (Ej....20101225) 2.- Select Holiday_code FROM tc_bank_holiday WHERE Holiday = day 2.1.- If (Holiday_code = 5 ) Then 2.2.- Select day_code from DM_Calendar Where Day = day 2.2.1.- If (day_code = 6 Or day_code = 7) Then 2.2.2.- Select.....

Hi,

This is posible, actually I do this Now, You need Ip DataStage Server, and when you get this, copy and pase in the file /system32/drivers/etc/Host after, log in datastage with user/pass... that's all..