DSXchange

More of a OS level problem. As far as i can get it i think when you try to run it with the sequence the job aborts and then when you manually run it it works just fine ? in that case you might want to see if the user which is created when running the sequence has rights to write to a file on the sys...

put this constraint on the accept link i.e. matching records with the hash file . check the reject row option for the second output link

Did you specify the data file in the MLoad option ? , try running it with pipes option check in the general tab. should solve the problem

This would pertain to metadata as you will be trawling through the DS repository in order to fetch the required information..........

Did you mean purge the last log before running the job again ?

thanks for clearing that one up. i was'nt sure on that

you might want to check what is causing the warning and value of that enviroment variable. PWD i think would have do something with the password for connecting to oracle ?

Would be a good idea if you could post the whole log then ?
p.s i think you might want to double check the values you are specifying for the enterprise stage. and what is pname ??

Can you shed a bit more light on where are you getting this error ? are you being able to view the file properly ? Are you using parameters?

good one for 1st april !

How many Amps do you have on TD ? Try the following and if this doesnt work read the Enterprise guide and follow the formula:

session per player should be set to 3

requested session should be set to 12

1.Just perform a join on the natural key columns and seperate the new records from the old ones 2.In the next step assign the surrogate keys to the new records. 3.Third would be the update. . P.S Are my DWH concepts outdated or your talking about type 3 and not 2 here because i thought in SCD type ...

if they reference each other then yes i think.............

why are you loading data from the hashed file in the first place? and how many records are there in the hashed file ? how big is the overflow file ?

There is a space and not a null as ArndW mentioned, so cannot use functions such as isnull() here. based on your statement which says there is "a" space. you can check for that and code that in the if then else