Search found 20 matches
- Mon Aug 27, 2007 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter values not passed from Datastage sequence to jobs
- Replies: 1
- Views: 1107
Parameter values not passed from Datastage sequence to jobs
Hi, We are facing thuis particular situation. When we call job from sequence, some of the paramter values are not passed to jobs. When we restart the ds Engine, it started working alright. But after some time, we are seeing the same problem. It is not happening always. It is sporadic in nature. Whic...
- Thu Aug 09, 2007 5:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing a record with the rest of the records in a table
- Replies: 4
- Views: 1747
Hi Joe, I did not understand exactly what you want to achieve. Are you looking for duplicate records. You may identify record order (1st and 2nd), if you have primary key defined in the table and using surrogate key or sequence number (in increasing order). But order may not be that imporatant as yo...
- Thu Aug 09, 2007 4:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change capture issue
- Replies: 4
- Views: 2146
- Thu Aug 09, 2007 4:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Please suggest
- Replies: 6
- Views: 2486
- Thu Aug 09, 2007 4:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To know new environment variables to be added when promoting
- Replies: 2
- Views: 1411
To know new environment variables to be added when promoting
Hi, I am looking for way to find the missing user defined environment variables in Production when promoting jobs from another instance. We are facing problems when developers add environment variables, and when admin promote jobs, they are unable to promote as environment variables are not availabl...
- Sun Jul 22, 2007 11:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC behaviour
- Replies: 4
- Views: 2097
- Sun Jul 22, 2007 7:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC behaviour
- Replies: 4
- Views: 2097
Re: CDC behaviour
Hi, In one of my job I'm using CDC, I have to src links (hash partitioned and sorted ASC on my key). In CDC stage I'm using change mode as Explicit Keys, All Values I have run the initial run where my target has 0 records; all records got inserted. I got the change record in my source, there is a c...
- Thu Jul 19, 2007 10:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compilation hangs forever
- Replies: 8
- Views: 2825
- Wed Jul 04, 2007 6:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC and comparing NULLS
- Replies: 7
- Views: 4058
PX jobs
We are working with px jobs
- Wed Jul 04, 2007 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC and comparing NULLS
- Replies: 7
- Views: 4058
-
We are working mainly with px jobs.
This particular issue is when building a px job
This particular issue is when building a px job
- Wed Jul 04, 2007 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC and comparing NULLS
- Replies: 7
- Views: 4058
- Tue Jul 03, 2007 10:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC and comparing NULLS
- Replies: 7
- Views: 4058
CDC and comparing NULLS
Dear DataStager's *************** Problem definition *************** We have a third party tool change data capture tool called OMNI that identifies all changes to our SAP source data and generates .csv files for consumption into data warehouse Under a given situation, I need to compare all the chan...
- Wed Mar 14, 2007 2:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generating random number in a specified range
- Replies: 19
- Views: 6388
- Thu Mar 01, 2007 12:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range lookups in PX
- Replies: 3
- Views: 1929
- Wed Feb 28, 2007 10:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Replace existing rows
- Replies: 32
- Views: 11830
If one want to achieve this by using one job only, they can use change capture stage. Where they can use before and after image of the record(s). with this, they can Identify inserts (new records), deletes (existing record in the target got deleted), updates or changes (changes made to record). We a...