DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 48 matches
Author Message
Resolved
 Topic: difference of dates
NBALA

Replies: 14
Views: 3606

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Oct 16, 2007 10:59 am   Subject: difference of dates
Hello ! Below post may help you..it will return a number then you can divide by 7



Thanks
 Topic: Title Case in Parallel
NBALA

Replies: 6
Views: 4949

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Oct 15, 2007 3:32 pm   Subject: Title Case in Parallel
If you use Oracle you can use the 'initcap' function


SQL> SELECT INITCAP('YOU TODAY') AS INIT_CAP FROM Dual;

INIT_CAP
---------
You Today
 Topic: Information Server
NBALA

Replies: 2
Views: 1306

PostForum: General   Posted: Mon Oct 15, 2007 3:17 pm   Subject: Information Server
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: Genral about the IBM 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) ...
 Topic: date format from flatfile to oracle database
NBALA

Replies: 13
Views: 4138

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Oct 05, 2006 11:13 am   Subject: date format from flatfile to oracle database
Thanks a lot Ken!

Wow ! It worked Great !

Thanks again.
-NB
 Topic: date format from flatfile to oracle database
NBALA

Replies: 13
Views: 4138

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Oct 05, 2006 10:11 am   Subject: date format from flatfile to oracle database
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 'DateYearFi ...
 Topic: Extraction Dates
NBALA

Replies: 14
Views: 3746

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Sep 22, 2006 7:45 am   Subject: Extraction Dates
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 sy ...
 Topic: Comparision of Hash and OCI lookup
NBALA

Replies: 5
Views: 1699

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Sep 21, 2006 2:06 pm   Subject: Comparision of Hash and OCI lookup
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 decre ...
 Topic: Comparision of Hash and OCI lookup
NBALA

Replies: 5
Views: 1699

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Sep 21, 2006 12:01 pm   Subject: Comparision of Hash and OCI lookup
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 compa ...
 Topic: Extraction Dates
NBALA

Replies: 14
Views: 3746

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Sep 15, 2006 12:10 pm   Subject: Extraction Dates
[quote="kduke"]Q1 has been answered.
Q2 use both todays date and the max date in your audit table.
Q3 use max date + 1 till today -1 because today is probably not complete.
Q4 You need a record in ...
 Topic: OCI has fetched truncated data
NBALA

Replies: 8
Views: 2614

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Sep 15, 2006 10:59 am   Subject: OCI has fetched truncated data
As Ray mentioned early it might due to the value which can not fit in the datastage data definition. Check the SQL type , Length and Scale.

-NB
 Topic: Reading and writing from the same file?
NBALA

Replies: 13
Views: 4516

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 15, 2006 10:50 am   Subject: Reading and writing from the same file?
This is possible if two different jobs are used, but not at the same time.

Could you explain the situation?

-NB
 Topic: Seperate Numeric field into two with Charcaters as delimitte
NBALA

Replies: 10
Views: 4246

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Sep 14, 2006 1:28 pm   Subject: Seperate Numeric field into two with Charcaters as delimitte
Hi,

You can use BASIC Field function,

Field (string, delimiter, instance Field("234455 * 82379", "*",1)

Will Returns 234455

Trim(Field("234455 ...
 Topic: Job Sequence completed successful even a job aborted status
NBALA

Replies: 16
Views: 13130

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 11, 2006 1:29 pm   Subject: Job Sequence completed successful even a job aborted status
Hi,

Check the Mail properties like SMTP mail server and From & To mail addresses (some mailserver could not mail thru internet like to your yahoo id).

And verify the triggers, you can use tr ...
 Topic: Extraction Dates
NBALA

Replies: 14
Views: 3746

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Sep 06, 2006 2:17 pm   Subject: Re: Extraction Dates
Hi,

Let me try to answer from my view point to your question.

you can have the audit table as below

Audit_key,
Source_name,
Process_Batch_number,
Batch_Extract_Date,
Processed_Row_Qty
...
 Topic: how to get the latest record from dimension table?
NBALA

Replies: 2
Views: 1438

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Sep 06, 2006 12:49 pm   Subject: how to get the latest record from dimension table?
Mad

Please do not make this forum junk ! This is not the first duplicate post from you Evil or Very Mad .

-NB
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours