Search found 142 matches
- Sun Jun 29, 2008 11:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle table load
- Replies: 4
- Views: 2389
Re: Oracle table load
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...
- Sun Jun 29, 2008 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD type 2
- Replies: 3
- Views: 2446
Re: SCD type 2
Yes, we can . hope this answers your questionsasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
- Sun Jun 29, 2008 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD type 2
- Replies: 3
- Views: 2446
Re: SCD type 2
Yes, we cansasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
- Sun Mar 25, 2007 11:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Spliiitng Sql query while extracting
- Replies: 2
- Views: 1687
Re: Spliiitng Sql query while extracting
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 ...
- Tue Mar 06, 2007 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order by Clause in Oracle Enterprise stage of Parallel jobs
- Replies: 5
- Views: 2596
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...
- Tue Mar 06, 2007 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Any limit on Target target tables in a job
- Replies: 3
- Views: 1832
Re: Any limit on Target target tables in a job
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...
- Mon Dec 04, 2006 8:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer : Job not visble when under 2 levels down....
- Replies: 4
- Views: 2466
Yes Ray, its XP pro and service pack 2 , not sure about the patch. How should i check for the installed patches for DataStageray.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? ...
thanks
regards,
prabu
- Mon Dec 04, 2006 10:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer : Job not visble when under 2 levels down....
- Replies: 4
- Views: 2466
- Mon Dec 04, 2006 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer : Job not visble when under 2 levels down....
- Replies: 4
- Views: 2466
Sequencer : Job not visble when under 2 levels down....
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...
- Sat Dec 02, 2006 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getColDesc failed
- Replies: 7
- Views: 3895
- Mon Sep 25, 2006 12:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Tricky Question
- Replies: 4
- Views: 2308
Re: Tricky Question
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 ...
- Tue Sep 12, 2006 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Persist Generated File Infile..Row_Generator
- Replies: 12
- Views: 5166
- Tue Sep 12, 2006 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need help
- Replies: 2
- Views: 2136
Re: need help
i know of one online documentvijaya 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
online doc
- Tue Sep 12, 2006 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading or writing the last record to a Sequential File
- Replies: 7
- Views: 3546
Re: Reading or writing the last record to a Sequential File
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...
- Tue Sep 12, 2006 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pass arguments to Unix script
- Replies: 6
- Views: 2877
Re: Pass arguments to Unix script
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...