DSXchange

Is it possible to compare a job in a project with a job in a ".dsx" file?

Regards,

Fernando Martins

Thats Worked!
Thanks a lot!
:D

Fernando Martins

Is it possible to export the Environment variables from one project to another?

Regards,

Fernando Martins

Ok, this is a little bit tricky. Before building the hashed file, add another column which is a surrogate key, a running number, i.e, 1,2,3..... and so on. Specify that as key and in the derivation of the lookup specify @INROWNUM so that each and every row has a hit. Define a stage variable to chec...

How does that affect the calculations?? you are doing lookup matching all your columns in lookup file with the main file? Krazykoolrohit it's almost this. :) main input = LINK_001 main_id dt_record lookup input = LINK_002 lookup_id lookup_desc dt_start dt_end rule: Only load the records where main_...

This is a simple lookup keyed on a single key with an extra condition that can be accomodated in the contraint. You constraint will look something like NOT(LookupLink.NOTFOUND) AND ICONV(dt_record,"D/MDY[2,2,4]") >= ICONV(dt_start,"D/MDY[2,2,4]") AND ICONV(dt_record,"D/MDY[...

as for the second condition. you will fetch the start dates and end dates. use these to calculate the eligibility for each row in a stage variable. ex: if dt_start > dt_record and dt_record < dt_end then 1 else 0 Krazykoolrohit I can't do "if LINK_002.dt_start > LINK_001.dt_record and LINK_001....

What you are trying to do is called a Range lookup or Multi-row lookup. You will have to use a Universe stage as a look up instead of hashed file.Click here . It's described in this post on how to achieve what you want. If you have any questions come back here. :wink: kris007 the link is broken and...

I need to apply one condition in a transformer and I'm little lost. :oops: rule: Only load the records where main_id = lookup_id and dt_record between dt_start and dt_end. - main input I have main_id and dt_record - lookup input I have lookup_id, lookup_desc, dt_start and dt_end. - target I have mai...

ArndW wrote:Yes you can. The command line needs to be an executable and not contain any parameters, but I've done something like make the command line "sh -c " and the command line options then contain "#JobParam ...

It's work!

Thanks a lot!

Fernando

Is it possible to put a parameter in the ExecCommand Activity Stage?

Thanks,

Fernando

I solved using change function

Thanks

Hi everybody!

My input is "0.678" and I need the following output "0,678".

Does anybody know how can I do this in the transformer?

Regards,

Fernando

Thanks!

Is it possible to do this with another job sequence?

Fernando