DSXchange

Guys, Your comments on the following...

"Because datasets are platform and configuration-specific, they should not be used for long-term backup and recovery of source data"

Thanks

Oracle table is partitinoned.

Now, how do I specify this table to be read in parallel? Are you suggesting that partitioned table will be read in parallel even though the "Executeion Mode" is sequential? If that is the case.....

Can I not read a partitioned table sequentially?

How do I READ ( Not write) in parallel using Oracle Enterprise stage.?

The "Execution Mode" tab is defaulted to Sequential and is greyed. How would I change this to Parallel?

Hi,
we are adding SAP APO to our existing SAP infrastructure. What are the components that need to be installed on SAP APO app server? Documentation says about 'cofiles' and 'datafiles'. But want to make sure I am not missing anything else. Can somebody help?
Thanks,
Rick

Hi Rick, the problem can be huge amount of data.else as u specified you using too many ABAP[4] stages.this will also lead to performance issue.what i can suggest u is,....u can use function Module calling and hence reduce no. of Abap Stages.Try this or else can u plz elaborate u problem in some dat...

Hi, I have an ABAP extract jon (there are other stages too). The job is taking more than 1.5 hours to complete. I found one extract (I have 4 other ABAP extract stages in this job) taking bulk of this time. I removed everything else and just kept one ABAP extract stage and wrote a flat file. Even th...

Hi, This is SCD job, reading from Delta file, with a Join on TD base table and finally inserts / updates the same table. Issue I am facing is, when I compile it simply hangs. It was compiling OK before. I added some null handling statements. If isnull(Link1.col1) then Setnull() else Link1.col1, so t...

Sorry Ray, was on vacation. This string can occur multiple times. If it occurs only once, what ever the way ArndW mentioned would work as you pointed out.

anybody has thoughts on this. Little more info, the part of the string I am trying to replace 'nta' can appear any where in the input string 'fantacy'.

Hi, I have an input string 'fantacy', I would like to covert this string to 'faxyzcy' in the TRANSFORMER Stage. That is 'nta' in the input string should be replaced by 'xyz' in the output. Only the occurrance of 'nta' need to be replaced but not the individual chars...so CONVERT function won't work....

Never mind I understood what you are saying.

I have the similar issue ( need to convert integer - 2006026 into date,yyyy-mm-dd format IN THE TRANSFORMER.).
Can you please tell me what format have you changed to get it to work. Please also mention your input data type and output datatype.

Using 7.5.1 PX.
Thanks

Hi, I would like to know the advantages and disadvantages in limiting the number of projects one can have on DS. Howmany projects do you have on your systems? Is it inefficient to have toomany ( toomany = >15 - 20) projects, will this cause unnecessary memory usage as system has to manage more proje...

DS 7.0 OS : UNIX job type parallel I was reading the old post and came across one of the posts. I pasted that post below..Here are my questions. 1. I found uv, under /xxxx/Ascential/DataStage/DSEngine/bin/, is this the $DSBIN you are referring to. 2. I tried all this following commands, ( PSEXPSLSE ...

Benny,

Can you post your 'GetLaterstJobLog' for me to get an idea how to do it? Thanks.