Search found 8 matches

by h4rd1
Tue Nov 17, 2009 8:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 5043

heloo


can any one help me with this ?

Thanks


Hardi
by h4rd1
Sun Nov 15, 2009 7:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL job filter data base on date supply by database
Replies: 6
Views: 3432

Thanks for the Help

i use parameter set and i add a job that supply the value into the parameter job file.

Thanks
by h4rd1
Sun Nov 15, 2009 6:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 5043

Image

i run it like this
by h4rd1
Sat Nov 14, 2009 8:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 5043

i consult with the dba and check all the session that connect when the job start. there is no any session that lock the table.

here is the screen shot of the job and also the log that i got from Director.Image

Thanks

Hardi
by h4rd1
Sat Nov 14, 2009 10:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL job filter data base on date supply by database
Replies: 6
Views: 3432

Thanks for the Reply

Can i directly do that in the job ?

Thanks


Hardi
by h4rd1
Sat Nov 14, 2009 10:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 5043

Thanks for the reply.

What kind of privileges that the user need ?


Thanks


Hardi
by h4rd1
Fri Nov 13, 2009 6:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL job filter data base on date supply by database
Replies: 6
Views: 3432

ETL job filter data base on date supply by database

Dear all

i'm new in using datastage, do any one know how to filter a data from source base on the date supply by database ?

Thanks


Hardi
by h4rd1
Fri Nov 13, 2009 5:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 5043

Oracle Stage load problem

Hi all i have a problem when loading data to oracle stage enterprise in write method : Load and write mode : append. i have a job to insert data from source to oracle for staging, ODBC >> Oracle Stage the problem is the job cannot finish, when i view the job, it's all stuck when loading data to orac...