DSXchange

Hi, I have a project running successfully on devl, but on moving to intg, am struggling with some settings issues because of which i am unable to run the sequencers. It seems like i am hitting some threshold (and am unable to figure out where to look for the param holding this threshold value, if an...

OK - the config.apt file was missing from the /etc directory - thanks Madhavan. I brought it over from devl and now i am able to execute orchadmin rm *.ds from the dataset directories

thanks

Configuration file with which these datasets were created is sitting in the Configurations directory. $APT_ORCHHOME is set to the PXEngine directory via administrator and also in dsenv. $APT_CONFIG_FILE is different for different jobs and hence the default one is defined at project level in administ...

Hi, I am trying to execute 'orchadmin rm *.ds' from the directories where the datasets are created through parallel jobs. I was able to do that on the developement server, but when i moved to the integration server (that has the exact same directory structure), i am no longer able to do that. Here's...

Try this

#FromClause# = prdtbl where $LoadType =1

craig,

This is what comes up when i run the dump

Typ=12 Len=7: 0,0,0,0,0,0,0

Thanks

Ray, When the job runs, it doesnt throw any error at all. Its when i query the tables later that i realize that it has this wierd value. Let me explain with an example to further elaborate on my problem. I may not have explained the problem right in my initial post. Source record: ------------------...

keshav, I do have a key column that i am using for update and i do have unique constraint on the table as well for that column, but again the problem is not with the key columns, its the date columns that are nullable columns and just other non-key attributes on the table. Instead of dumping a null ...

kumar_s,

I didnt get your question, but if you are asking about DB, its ORACLE 10g

Hi, I have a job with just two ORA stages and all i am trying to read data from a source table and do an upsert on the target table. There are no other stages inbetween these two stages. A select query runs in first ORA stage and it has some date columns. In the target stage, i have a user-defined U...

Thanks Kenneth,

I still cant understand why, but doing what you suggested made my job work Must be some silly math algorithm issue as you said.

Thanks

There is a new problem with this same job. I have the row generator, column generator operating in sequential mode (initial value:0, increment:0.01) and then i am removing duplicates generated. but now i realised that there are couple values that are missing consistently. For this job that generates...

Hello friends, Kindly help me figure out how to implement this requirement the best way. We have source data coming from multiple db's and the first step we do is to stage them locally. And sometimes one of the sources would be unavailable at the time of load and when that happens we still would wan...

I forgot to add that i also added a hint to the source SQL, /*+ PARALLEL (tablename) */ and i think that also helped faster reads, but i would definitely like to work more on the lines of increasing network throughput to gain some more performance.

Thank you again ArndW, I think we are in the right track, as the performance increased, i'd say i saw double the speeds that i had initially when i split up the source into 2 oracle stages. But i need to increase it further, as its now loading 23 mil in 14 min or so. But i am not sure i understand h...