I am also thinking of another approach.
1. Keep update action in CDC job.
2. Load inserts into a dataset.
3. Build a generic load job with RCP & parameterise dataset file name & table name.
4. Use load RCP job for all inserts.
Search found 36 matches
- Mon Apr 03, 2017 8:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update Oracle table in CDC job?
- Replies: 4
- Views: 2126
- Mon Apr 03, 2017 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update Oracle table in CDC job?
- Replies: 4
- Views: 2126
Thanks for your reply chulett. Sure, i will test in both the ways.If performance is same in both the ways, then i would like to build insert/update actions in CDC job. I am seeing following advantages in this way. 1. If suppose i have 100 tables, then if i need to build separate jobs for inserts/upd...
- Sun Apr 02, 2017 8:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update Oracle table in CDC job?
- Replies: 4
- Views: 2126
Insert/Update Oracle table in CDC job?
Hi All, We are trying to build a new data warehouse, i am currently doing POC, we will have multiple tables in warehouse, we will build CDC job for every table to capture the data changes. In every CDC job i am planning to capture inserts into a dataset & edits into another data set. Next i plan...
- Tue Nov 01, 2011 8:07 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to join two tables in IA
- Replies: 4
- Views: 4644
- Thu Oct 27, 2011 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert 2 digit year to 4 digits
- Replies: 6
- Views: 5820
Re: Convert 2 digit year to 4 digits
SV1: Right(YearFromDate(CurrentDate()),2)
SV2: If Input <=SV1 then '20':Input Else '19':Input
Mostly we uses this logic, i hope it will solve your problem....
SV2: If Input <=SV1 then '20':Input Else '19':Input
Mostly we uses this logic, i hope it will solve your problem....
- Thu Oct 27, 2011 7:46 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to join two tables in IA
- Replies: 4
- Views: 4644
How to join two tables in IA
Hi, I am new to Information Analyzer, i started working on column analysis, virtual columns and virtual tables. I am facing one problem, I am trying to perform join on two tables and next column analysis on select fields. I am not able to join two tables while creating virtual tables. Could anyone p...
- Tue Aug 30, 2011 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to change date to quarter
- Replies: 1
- Views: 1788
Re: how to change date to quarter
You can get ur results from following stage variables.
sv1: MonthFromDate(input_date)/3
sv2: Ceil(sv1)
sv3: 'Q' : sv2 : YearFromDate(input_date) [3,2]
sv1: MonthFromDate(input_date)/3
sv2: Ceil(sv1)
sv3: 'Q' : sv2 : YearFromDate(input_date) [3,2]
- Mon Sep 27, 2010 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: USERNAME AND/OR PASSWORD INVALID
- Replies: 1
- Views: 3680
USERNAME AND/OR PASSWORD INVALID
Hi All, I have a issue, and i tried myself to trace the problem but it didn't work. Issue:- I have a px job and have 3 environments(Dev, Test, Stage). Job running fine in Dev and Test, but it's keep on failing in Stage with below fatal error. [IIS-CONN-DB2-000004] DB2 function SQLConnect failed: SQL...
- Thu Feb 04, 2010 10:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: BigInt
- Replies: 3
- Views: 3110
- Mon Jun 15, 2009 11:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Shared container compilation error
- Replies: 5
- Views: 4917
- Mon Jun 15, 2009 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Shared container compilation error
- Replies: 5
- Views: 4917
Shared container compilation error
Hi, I am using one shared container in one of my job, after completion of 2 or 3 runs of job, i found one issue in shared container and modified it and saved. Now i am not able to run the job from designer, it is giving one message like 'The following referenced Shared Container(s) have been modifie...
- Sun Dec 16, 2007 4:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting status of Executecommand stage in sequence
- Replies: 2
- Views: 1721
getting status of Executecommand stage in sequence
Hai, I have a problem while designing sequence job. My flow is like below Exec1====>Exec2===>Exec3===>Exec4 Here i am executing one shell script with multiple parameters using 4 executecommand stages. if exce1 is successfully completd then Exec2 will start.and exec3 and exec4 also depend on the succ...
- Fri Dec 07, 2007 3:58 am
- Forum: General
- Topic: Same sequential file as the source and the target
- Replies: 10
- Views: 4412
Re: Same sequential file as the source and the target
Hi , I have a situation wherein I need to use the same Sequential file as the source , do some transformations and then load this data into the same sequential file which will have the updated data for the next run. Please help... :) Create 2 jobs ,in first job take one temporary file as target and...
- Thu Dec 06, 2007 6:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert Date format using Moify stage
- Replies: 3
- Views: 2257
- Thu Dec 06, 2007 6:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert Date format using Moify stage
- Replies: 3
- Views: 2257
How to convert Date format using Moify stage
Hi, I am facing one problem while converting date format.First my source is a fixed width file.one of my column contain date type records, but i am reading it using char data type.My sourec is 10120/01/2007aaa 10212/12/2007bbb metadata: id char(3) effdate char(10) name char(3) In file date is in dd/...