DSXchange

Hello Please mention all the possible ways to increase the load speed (for Oracle load). Hi, For fact load ======== 1) If it is an append of records, load into a temporary table . then exchange this temp table into the daily partition. 2) go for bulk/direct path load. 3)Run the load stand-alone (As...

sasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi

Yes, we can . hope this answers your question

sasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi

Yes, we can

Hi, I am designing a job which is pulling data from the oracle database.The sql used for this has 2 UNIONs with 2 oracle views(sometimes more thatn 2). So, usage of 2 Oracle stages in the design will be any adavantageous in terms of performance while extracting? There are no partitions created for ...

As suggested above you can either use User Defined SQL query of use SQL builder for Orderby clause. There is a work arround, add WHERE Clause option and enter WHERE condition and after that you can write ORDER BY...... If you do not have WHERE condition for the SQL, still add WHERE Clause option an...

Hi All, Is there any limit on the number of source stages and Target stages per job. Any ideal solution apart from splitting it into sub jobs Thanks in Advance. IMHO, there is NO limit to the number of target tables used in a single job. saying that, you need to consider splitting the load into mul...

ray.wurlod wrote:Is your operating system Windows XP Pro with service pack 2 and, if so, do you have the DataStage patch for this combination installed? ...

Yes Ray, its XP pro and service pack 2 , not sure about the patch. How should i check for the installed patches for DataStage

thanks

regards,
prabu

thebird wrote: But is this happening in the Job Activity? Meaning - are you not able to see the job in this activity?


Aneesh

that's true

Hi DS Folks, i am facing a very strange issue. The sequencer is not recognizing the jobs when it is under 2 levels down Say we have the following structure:- Sequencer is Job P1 M1 the sequencer doesnt recognize M1 folder . it recognizes till M1 [meaning, when jobs lie under till p1. it`shows M1 und...

keshav0307 wrote:i tried but its doen't help me, so i put a new post

This error is due to the

ORCHESTRATE Oracle driver

not installed properly.

Please reinstall the drivers [should be in your ORCH_HOME/install dir]

Hope this helps

regards,
Prabu

All, There are two columns as follows in a sequential file. I am using unix to write this output. And I am reading one line at a time. col A Col B a 1 a 2 a 3 Output should look like Heading a 1 2 3 Can you please help me. Thanks not so tricky answer :wink: :wink: cat myfilename.dat | awk -F, '{if ...

vijaya wrote:Hi all,

Please send me good documents on how to do jobs in Px becoz i need to get femeliar with this jobs.Dont ignore this message i am need of this documents hardly

i know of one online document
online doc

Hi, I have a source text file which has 10 recs and I am having a few transformations in the middle and putting the output to a sequential file again having 10 recs. Is there any way I can write only the last record i.e. the 10th record to the file. Thanks, check for @OUTROWNUM and mod function. Bu...

I have JobName and JobNo fields whch i want to pass into unix script as arguments.There are number of records for those two fields. How can i pass JobName and JobNo to unix script ? Pls suggest your ideas for same. if it is unix specific, Meaning, you want to pass variable argument to a shell scrip...