DSXchange

If you can get your work done with the tools you have, dont need to invent a new one. So yes, for simple tasks as trim and renaming you can use transformer and modify stage. You dont need to build an extra stage for that. As Kumar noted, utilize buildops for functionlity not readily available from ...

Once I made similar benchmarking, Join gave be better result. But I dont have any of those details right now. But I will still wait for your results to be published, Munish. Make sure your CPU usage idle for all the cases. Do also measure the memory and CPU usage during the operation. Any Updates o...

First option for environment variable and second for just the job parameter. Try this, just specify a job parameter and see if that works. ... Thanks a ton DSguru2B. You are a DSguru already to me :) It worked atlast using Job Parameter . Thanks again Defined Env variable, and assigning to Job Para...

You should be able to use the parameters. I am not a big fan of making all parameters as environment variables, but I test it out in a dummy job and it works here. How did you define the environment variable in the first place? Go to the job properties, click on "Add environment variables"...

DSguru2B wrote:If you hardcode the value. Does it work fine?

Yes...Hardcoding works...But I'm trying to find a way to make it work when it moves from one environment to another...say from TEST to PROD.

DSguru2B wrote:How are you parametrizing it. Make sure you surround it with hashes. Plus you need to give the instance name for Data Source. ...

Tried using #$RUNMODE#; #RUNMODE# and other options, but no good

Hello folks, I am trying to create a build op. I right-clicked stage types in DS Manager and selected New Parallel stage. On the stage type "GENERAL" tab this is what I entered stage type name ---> eng_dis class name ----> eng_dis I have not entered anything in CREATOR & PROPERTIES Ta...

Parametrize it. Pass it as a parameter to your stored procedure. I have an User defined Environemnt variable [$RUNMODE] which is referenced as Job Parameter, and I'm using $RUNMODE in Data Source tab, but it's not resolving giving me the following:- SP_CDDM,0: Error: [IBM][CLI Driver] SQL1013N The ...

Hi, I have a Stored Procedure stage for DB2. In this stage I have to pass Data Source which can be Unit Test environment [XXXX] or System Test environment[YYYY] or Production environment[ZZZZ] These XXXX/YYYY/ZZZZ are hard-coded values now. When I move this Job from one environment say from one Test...

ray.wurlod wrote:The Lookup stage has its own "Constraints" area - click on the second tool from the left in its toolbar. ...

Ray,
The Constraints list the reference link and the derivation bar for the constraint doesn't allow me to select any Input Column. Thanks again for all the inputs.

You can have a reject link coming out of the Lookup Stage that will carry records which will fail the lookup. Send both the inputs (lookup successful and lookup failure which is the reject link) to a funnel stage. The output of funnel stage can go to your final dataset. Thanks for the suggestion. I...

Hello, I have a scenario, wherein I have a Dataset==>Transformer==>Lookup==>Dataset There's one set of records [Input Field1=00]in Input wherein it wouldn't find a Lookup in the Reference, and it should just pass the entire Input record to the Output. For the rest of the records [Input Field1 <> 00]...

Same command. And a friendly reminder, "No Hijacking of threads." Thanks..Will try it out. And didn't mean to Hijack this thread, as this thread is marked 'RESOLVED' and I didn't want to open a new topic on the same subject :P Thanks again and the trick worked with GetEnvironment() Utilit...

Brian was right! There is GetEnvironment in Utility will help you get the value of any environment variable. Go to Utility ->GetEnvironment in derivation editor, and provide the syntax like GetEnvironment("APT_CONFIG_FILE") will do the trick for you... My previous method will also do this...

DSguru2B wrote:Or you can always have an empty file say "aaam_classif_empty.txt" to ensure that your job finishes successfully. This will eliminate any extra job or stages.

You just beat me in posting the reply
Yes having a dummy-empty file always in that folder would solve your issue.
-Vijay