DSXchange

Did you try doing that in a Transformer/Filter stage downstream? yes , so wen lookup on ID only , multiple entries are present in reference table for a ID then only one entry gets picked up and other wont and lookup stage has option to return multilple row only for one reference link. not more for ...

Try this Main.EFF_DT >= reference.EFF_DT AND Main.EFF_DT <= reference.EXP_DT Main.EXP_DT >= reference.EFF_DT AND Main.EXP_DT <= reference.EXP_DT I can not edit look up range expression. Main.EFF_DT >= reference.EFF_DT AND Main.EXP_DT >= reference.EFF_DT This means I am comparing eff_dt and exp_dt f...

Use range lookup for start_date and end_date Tried using same getting error in compilation as ##E IIS-DSEE-TFKL-00079 15:08:02(009) <transform> Error when checking composite operator: Error parsing range option. Comparison operators can't be of the same type "Main.EFF_DT >= reference.EFF_DT AN...

Hi Need to look up a value with constraint(as in stream records start date and end date should be between reference records start date and end date) In look up stage, doesn't seems to do the comparision in my case, is there any other way to do look up with constraint Main stream data has ID, start_d...

Do we have a stage in parallel verison which will combine the columns two columns data to one column as below

column1 column2
A F
B G
C H


out put

columnout
A
B
C
F
G
H

Hi, Actual these are the SCD 2 type source tables. means for ID = 1, we have all previous changes history with effective and expiration date in both the table. And output is join of these tables. Product X was priced 100rs for year 2000 to 2006 product X was priced 200rs for year 2006 to 2009 a prod...

two history tables with each record having effective date and end date needs to join (date is in dd/mm/yyyy) table one effdate enddate ID Name 01/08/2010 04/08/2010 01 devendra 04/08/2010 06/08/2010 01 deven table two effdate enddate ID Family 01/08/2010 02/08/2010 01 X 02/08/2010 03/08/2010 01 Y 03...

"Do not checkpoint run" option is not checked.

Yes I checked "Automatically handle job runs that fail"

Also I have "Add checkpoint so sequence is restartable on failure"

Both at seq1 level.

Then I have "Reset if required then run" selected in each job activity

Thanks.

In Job activity I have selected "Reset if required then run" so that I need not to compile the job (in case no change in design). Is that correct?

I have 3 jobs J1, J2, J3 in seq1 as J1--> J2 --> J3 "Reset if required then run" is checked in each of 3 job activites "Add checkpoint so sequence is restartable on failure" is checked at Seq1 level In first run if J1 is successful and J2 is aborted then Seq1 is aborted. I will p...

Hi

What is the difference between Sparse Lookup and Normal Lookup?

Hi

We are getting a error "Fail to open job" when we run dsrun command on unix box. where as if I run it from datastage director it runs successfully.

Hi I have after routine , Exec Shell where I am try to concatenate 3 files. When I concatenate these files using datastage after routine , there is no new line character when data between two line concatenate. So the data from new starts on the same line as old file data ends. where as on command pr...

Hi I need to enter following data in seqeuncial file. Name Address Timestamp abc|123|456 edc|567|789 piu|345|567 EndofFile Endofchar Here first 3 rows and last 2 rows are static and rest of the rows are retrived from database table. I was trying to do this in 3 jobs, 1st job write first static part ...