DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 193 matches
Author Message
 Topic: insert/update with no key
dnat

Replies: 1
Views: 6

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 21, 2017 12:20 pm   Subject: insert/update with no key
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have to load a oracle table from a file. There are no keys in the table. In this situation what would be the best approach to load the table with restartability in place..If the job aborts in ...
Resolved
 Topic: Date format issues
dnat

Replies: 2
Views: 96

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 12:13 pm   Subject: Date format issues
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have a date in the file as 10/11/17 and i am trying to load it into the table.

When i use this function StringToDate(Trim(DSLink2.File_Date),'%(d,s)/%(m,s)/%yy'),

I tried to output in a ...
Resolved
 Topic: Problem in reading .csv file
dnat

Replies: 5
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 12:05 pm   Subject: Problem in reading .csv file
Thanks for all your inputs. I added the "Record delimiter string" to DOS format and was able to read the file as it was.
Resolved
 Topic: Problem in reading .csv file
dnat

Replies: 5
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 09, 2017 5:28 pm   Subject: Problem in reading .csv file
Yes, they are all defined as Strings. And i will be converting those fields as required inside the job.

But now the problem is with reading the file itself. While i view data in sequential file sta ...
Resolved
 Topic: Problem in reading .csv file
dnat

Replies: 5
Views: 176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 09, 2017 4:25 pm   Subject: Problem in reading .csv file
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have a .csv format file and it comes in the following way
...
 Topic: Hash value in output
dnat

Replies: 1
Views: 539

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 13, 2012 5:06 am   Subject: Hash value in output
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I would like to output a key value(Like hash key) for the input which i send. For the same values i would need to get the same key values all the time.

For example

For the value "xyz, bg ...
 Topic: update very slow
dnat

Replies: 4
Views: 1489

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 23, 2011 12:20 am   Subject: update very slow
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have a job which reads a file and updates a table(oracle) based on the unique key of the table.
The file has 100 million records.
The job has been running for more than 30 hours now and th ...
 Topic: sparse lookup-join
dnat

Replies: 4
Views: 1889

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 20, 2011 12:32 am   Subject: sparse lookup-join
I dont think we have range lookup in 7.5.1?
 Topic: sparse lookup-join
dnat

Replies: 4
Views: 1889

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 17, 2011 2:09 am   Subject: sparse lookup-join
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

We have used sparse lookup in a job where the condition in the oracle stage is select value from table where lowsc<=orchestrate.sc and highsc>=orchestrate.sc.
So, i pass the field "valu ...
 Topic: improving performance
dnat

Replies: 2
Views: 1163

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 13, 2011 1:46 am   Subject: improving performance
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have several datastage jobs which run to update multiple dim and fact tables in a data warehousing application.

Most of the jobs take around 3 to 4 minutes to complete and 2 or 3 jobs take ...
 Topic: isnull function
dnat

Replies: 8
Views: 3526

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 06, 2011 1:44 am   Subject: isnull function
Hi,

i manually typed in the code, just to mention that i am using a isnull() function.

When i see the input data through datastage using "View Data", the fields are having values as "NULL". And ...
 Topic: isnull function
dnat

Replies: 8
Views: 3526

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 04, 2011 11:08 pm   Subject: isnull function
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have an oracle stage as input where there are null values in field A.

The next stage is a transformer, and in the stage variable i want to do some validations based on the field A's value. ...
 Topic: connection between job and sequencer
dnat

Replies: 4
Views: 1347

PostForum: General   Posted: Tue Feb 15, 2011 5:07 am   Subject: connection between job and sequencer
No, nothing was changed in the job in the recent past..
 Topic: connection between job and sequencer
dnat

Replies: 4
Views: 1347

PostForum: General   Posted: Tue Feb 15, 2011 3:40 am   Subject: connection between job and sequencer
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have a Job sequence like this which calls multiple job sequences like this

Job sequence1-->Job sequence 2-->Job sequence3-->Parallel job1

Job sequence 3 has aborted with the er ...
 Topic: not able to connect to oracle
dnat

Replies: 1
Views: 888

PostForum: General   Posted: Mon Feb 07, 2011 4:31 am   Subject: not able to connect to oracle
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have a sequencer which calls another sequencer which in turn another sequencer. It has been running fine for a while without any issues. Now suddenly i am getting the ORA-12541 error when the ...
 

 Jump to:   



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