Search found 28 matches
- Mon Apr 27, 2015 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC not giving desired results
- Replies: 7
- Views: 3920
- Mon Apr 27, 2015 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC not giving desired results
- Replies: 7
- Views: 3920
CDC not giving desired results
I am using CDC stage in one of my parallel job. Initially, my target table is empty. First time CDC outputs 10 rows (which are new rows). Next time when I run job it gives same 10 rows for update with change_code=3, which is not correct because this time it should output no rows.
- Fri Apr 17, 2015 3:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding RCP Enabled Job
- Replies: 6
- Views: 3471
Re: Regarding RCP Enabled Job
In connector use Before SQL and do following;
CREATE TABLE T1
(
Column_Name Type PRIMARY KEY
)
;
INSERT INTO T1
SELECT Column
FROM Table_1 , Table_2
WHERE Table_1.column = Table_2.column;
Then extract data to Data Set
CREATE TABLE T1
(
Column_Name Type PRIMARY KEY
)
;
INSERT INTO T1
SELECT Column
FROM Table_1 , Table_2
WHERE Table_1.column = Table_2.column;
Then extract data to Data Set
- Tue Apr 14, 2015 2:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extract Multiple table
- Replies: 1
- Views: 1523
Extract Multiple table
Is there any configuration for extracting multiple tables of same database into multiple Data Set using single connector(On Single DB Connection).
My DBMS is DB2.
My DBMS is DB2.
- Tue Mar 17, 2015 7:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Detect Capture(CDC) Stage overview
- Replies: 3
- Views: 2597
- Mon Mar 16, 2015 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Detect Capture(CDC) Stage overview
- Replies: 3
- Views: 2597
Change Detect Capture(CDC) Stage overview
My job Design is Like Source1==>SortStage1==> CDC Stage ==> SortStage3 ==> Target Source2==>SortStage2==> My questions are; 1: As CDC has built in option regarding sorting data so, before CDC using Sort stage is bad approach and is this performance overhead? 2: Is it CDC Stage output data is sorted ...
- Wed Jan 28, 2015 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Sequential File including Null o Spaces
- Replies: 5
- Views: 2529
- Wed Jan 28, 2015 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Left outer Join not resulting Null values of right table
- Replies: 3
- Views: 1971
- Wed Jan 28, 2015 9:57 am
- Forum: General
- Topic: DataStage Job's auditing
- Replies: 9
- Views: 6102
Thanks for reply Go into DataStage Administrator, open your project settings, and enable the option to collect Operational Metadata. We need to do auditing without enable Operational Metadata. If you are using DataStage Operations Console (and its associated database) this information is already bei...
- Tue Jan 27, 2015 11:10 am
- Forum: General
- Topic: DataStage Job's auditing
- Replies: 9
- Views: 6102
DataStage Job's auditing
I want to store job information like Job Name, Job time before job started and after job ending(Succfuly or failure).
Kindly give in detail procedure to achive this task.(Ideal senario)
Kindly give in detail procedure to achive this task.(Ideal senario)
- Tue Jan 27, 2015 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Left outer Join not resulting Null values of right table
- Replies: 3
- Views: 1971
Left outer Join not resulting Null values of right table
After left join its right table columns having varchar datatype value should be NULL but columns have values like empty single quote ''
- Tue Jan 27, 2015 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Sequential File including Null o Spaces
- Replies: 5
- Views: 2529
- Wed Jan 21, 2015 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Sequential File including Null o Spaces
- Replies: 5
- Views: 2529
Reading Sequential File including Null o Spaces
I have file whose 1st and last row is enter, NULL or space when I set sequential file stage formatting even nullfield to '' it's not inserting . Let me know how i can read all records even empty one having space,enter or Null. Formate as below 1. 2. 00001 T , N N MO 021698 DM UNFI . . .... 45050
- Tue Jan 20, 2015 11:56 am
- Forum: General
- Topic: Specific patterns file name and path change
- Replies: 4
- Views: 1970
- Fri Jan 16, 2015 10:57 am
- Forum: General
- Topic: Specific patterns file name and path change
- Replies: 4
- Views: 1970
Specific patterns file name and path change
How to move to another folder and rename specific pattern files using shell script in Datastage like file_name_currentDate()_123.txt to file_name to file_name_olddate.txt ?