Hello ! Below post may help you..it will return a number then you can divide by 7
[url]viewtopic.php?t=107280&highlight=date+difference[/url]
Thanks
Search found 47 matches
- Tue Oct 16, 2007 10:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: difference of dates
- Replies: 14
- Views: 6563
- Mon Oct 15, 2007 3:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Title Case in Parallel
- Replies: 6
- Views: 6634
- Mon Oct 15, 2007 3:17 pm
- Forum: General
- Topic: Information Server
- Replies: 2
- Views: 2167
Information Server
Hello All ! Just thought of sharing some information. Do we need a separate topic for IBM Information Server? (To discuss issues in Installation, migration, upgrade, and configuration information) some general info - With the version 8 release IBM introduced the Information Server with a new look in...
- Thu Oct 05, 2006 11:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date format from flatfile to oracle database
- Replies: 13
- Views: 6142
- Thu Oct 05, 2006 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date format from flatfile to oracle database
- Replies: 13
- Views: 6142
Hi, Any one please help me ! I have a date and time format like '20061003191438' (yyyymmddHHmmss) as input date from source. I want to load this in Oracle date. I have tried with 'DateYearFirstToOraOCIWithTime' but its returnig with some date with charaters like 2016-BC-07... Any suggestion apprecia...
- Fri Sep 22, 2006 7:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction Dates
- Replies: 14
- Views: 5904
Hi, The sequence looks ok. In check audit table sequence - first increase the batch number for the Src (A or B or C depends on the your source) insert new row with incremented batch number and system date as extract date. Yes, you have to write into table when they triggered. //// The doubt here I h...
- Thu Sep 21, 2006 2:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comparision of Hash and OCI lookup
- Replies: 5
- Views: 3033
Thanks all ! The dimension has around 100,000 rows(in one of the Dim), I tried to use OCI but getting poor performance like 8 rows/sec. It started with 121 rows/sec then it started gradually decreasing the number of rows.. fact is having 1.3 million to load. I will try with hash and check the perfor...
- Thu Sep 21, 2006 12:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comparision of Hash and OCI lookup
- Replies: 5
- Views: 3033
Comparision of Hash and OCI lookup
Hi, Hope this might be discussed earlier, when searching I could not get right answer. Situation : Consider a fact table contains 7 dimension and need to lookup all 7 dimensions. While comparing hask lookup and OCI lookup which one will be best choice? and which will give good performance? Which wil...
- Fri Sep 15, 2006 12:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction Dates
- Replies: 14
- Views: 5904
- Fri Sep 15, 2006 10:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI has fetched truncated data
- Replies: 8
- Views: 8116
- Fri Sep 15, 2006 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading and writing from the same file?
- Replies: 13
- Views: 6431
- Thu Sep 14, 2006 1:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Seperate Numeric field into two with Charcaters as delimitte
- Replies: 10
- Views: 6730
Hi, You can use BASIC Field function, Field (string, delimiter, instance [ ,number] ) String is your input - 234455 * 82379 in your case delimiter is the character that delimits the substring instance specifies which instance of delimiter terminates the substring. number specifies the number of deli...
- Mon Sep 11, 2006 1:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Sequence completed successful even a job aborted status
- Replies: 16
- Views: 16123
- Wed Sep 06, 2006 2:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extraction Dates
- Replies: 14
- Views: 5904
Re: Extraction Dates
Hi, Let me try to answer from my view point to your question. [b]Q1:[/b] you can have the audit table as below Audit_key, Source_name, Process_Batch_number, Batch_Extract_Date, Processed_Row_Qty Initialize the table with Source Names like below 1, SorA, 1, NULL, 0 2, SorB, 1, NULL, 0 3, SorC, 1, NUL...
- Wed Sep 06, 2006 12:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to get the latest record from dimension table?
- Replies: 2
- Views: 2830