DSXchange

Hi To check the reject file, there are many ways, either you can use a execute command stage and have a unix command like cat and see if there is any output or do a link count. For job3, read the new source file (the reject file that has been renamed) and send it to transformer, in the Xfm do the da...

Ho about have 2 jobs and then looping it. Jobs 1: read source file , do the look up and reject records that do not match. Job2: Using exec command stage, rename the reject file as source file Job3: Similar to job1 , but will take the new source file and minus 1 day and apply the look up again and re...

Ok, thank you guys, FYI wanted to extract attributes from AD based on the ID, will go the java pack way.

Hi All

Is there a new stage in 8.1 to access AD/LDAP?

If I design the job that way and manually type in the column name in Lookup2, job compiles and even runs fine without aborting, was just curious if this was a bug in DS.

Thanks

Hi,

Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?


i.e result of look up1 is the key for lookup2

Thanks,

Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?


i.e result of look up1 is the key for lookup2

Thanks,

Hi, I have used the Field function, my source column has 3 values delimited by '-' and I needed 3 output columns , the following are the derivations for the 3 output columns, SourceCol=201-232-9090 Output Col1=201 ---->Field(SourceCol,'-',1) Output Col2=232---->Field(SourceCol,'-',2) Output Col3=909...

I have got this to work using the Field function, thanks !

Hi,

I am not trying to repalce the '-', I need to parse or extract 3 columns from one , if it is 12-34-5, then I need 12, 34 and 5 as separate column values.

Thanks,

Hi, I am reading from a table and one of the columns has the following sample data, I need to parse the data and extract 3 fields , the delimiter is '-' Source: 205-51-510203 Required Output: 205 51 510203 Source: 201-1-10001 Required Output: 201 1 10001 Source: 202-14 Required Output: 202 14 Source...

You have the software on the Acential or IBM cd, if I am not wrong.

I had Decimal and Char as key columns and I changed it to Decimal and VarChar, still the same 1403 error and all the source rows are rejected.

Curious , if it does not find the key coulmn shouldnt the job insert the row ?

Thanks

Hi, When I run a job which reads from SQL and loads into Oracle table using Oracle Ent Stage, I get the "sqlcode:1403 " error. When I take the Update stmt from the stage and execute it in Toad it works fine ! I did try to change the 'Update Else Insert' option to 'Insert else Update' but i...

There was a trigger constraint that had to be dropped, so the sql code error was not help full!

Thanks for all your responses.