DSXchange

Hi, My job reads data from Oracle table by using 4 node configuration, but data is being selected in only one node all other nodes are having just zero records. issues is: in datstage directore it shows like GL001P,1: Output 0 produced 0 records. GL001P,3: Output 0 produced 0 records. GL001P,2: Outp...

Hi, I have a job that I have to run trhu the number of days in previous month. For example if the previous month is Jan or March 31 days. In Feb 28 or 29 depending on leap year. Any thoughts? Thanks You can try using the below oracle query to get the number of days in previous month and then loop y...

Hi, I have a job that I have to run trhu the number of days in previous month. For example if the previous month is Jan or March 31 days. In Feb 28 or 29 depending on leap year. Any thoughts? Thanks You can try using the below oracle query to get the number of days in previous month and then loop y...

we are using 4-Node configuration file. main_program: Startup time, 0:29; production run time, 39:47. This job reads data from sequential file and loads into oracle table, between date and timestamp transfiormations are happening in transformer. and Onelookup checking for referential integrity. it's...

but by changing this some times, job status in detailed log is Finished.
but view status shows old run status, not at all triggered.

We need to move from 5.2.1 TO 8.X.
Can export datastage projects and import to new projects ?
is there any other work ? will all the jobs will work ?

Thanks Ray i asked DBA to trace this issue but after 2 days analysis he is not able to get any clue why its happening. Do you have/or if anyone have any inputs/suggestions for him.I mean from where he should start and what all he should look for. As you said this is nothing to do with DataStage but ...

Hi, I am encountering one issue while selecting data from table.Sometime Job goes fine and sometime it fails with error message.. "Access to sys.dba_extents required but not available. please see the your dba for select privileges" I checked all priv are there and many times we were succes...

Hi All,

Job schedule on a specific day (eg., on Saturday Tuesday) getting aborted, where as when i schedule the job to run TODAY it is running perfect.

Would appreciate if anyone helps me out

Thanks in advance[/i][/b]

Thanks chulett for your's response,

we had the permissions to disables the constraints,but we are using the DB2 load stage to load the data,

Let me know how to disabled the constraints, which property needs to be set in DB2 load stage

Hi,

Let us know how to disabled the constrints while loading the data to DB2 databse table,

Hi,

We need to load 5GB data to DB2 tables with applying some transformations,

Can you please suggest which stage can use to Load(DB2/UDB Enterprise stage or DB2 API Stage,DB2/UDB Load stage) the data

Please suggest which is faster load the data,

Hi, I installed Datastge and db2 in one server, i am unable to import the metadata, while importing meta data by using ODBC table definition i am getting the below error, DSR.MetaGeta(GET.TABLES)(SQLConnect('gifdb2db','root')): BCI Error: SQLSTATE=HY000,CODE=1222,[DataStage][SQL Client][ODBC][DataDi...

Thanks Ray for you suggestion,

I need to put 24 input links for lookupsatge in one of my requirement, is it any impact on performance, input data only 1000 records,

Hi, Can you please give the suggestion for the below task, my source:(file) month1,month2,month3,month4--columns 1,2,3,4 2,1,3,4 ---data Lokup table: months: 1 2 3 So my requirement is i need to check the each column from the source to lookup column and pass the record to target, is it possible take...