DSXchange

HI to all, This is satish. I am working on DataStage 7.5. I Am planning to take a certification on DataStage. Please provide the information if any bocdy knows.(Where i want take test, some sample questions,material and any related website links) Thanks&Regards, satish. follow this link http://...

Oracle database

any other method, CDC is not that fast.

No, all files have different file format. so, we can not use Unix cat command.

Hi , I have 100's of millions of records in table "A" and I have daily maintenace coming for this table "A" as text file . THis text file also have millions of recods everyday. THis txt file data coming for insert/update, this upsert data range from anywhere in history daya . Wha...

Hi,
I have following scenario -
eg. I have 100 different txt file coming from different source and I want to load into one oracel databse table using one datastage job .. how can I achive this. ?


Thanks in advance.

RP

Please check all input of funnel and make sure the name /type and lenght should be match . something is not matching correctly in both input.

Hi All,
Can someone help me on this -

I want the return code from Datastage job (successfull or not,0/1) back to Unix, so, I can run my process which depends on (un)successful completion of DS .

How can I get this ?

Please advise.

Hi, I have following scenario I want to test the date (coming from txt file) before I load into the table. date may be coming as null or 00000000 or 20051025(YYYYmmdd) how can I handle that before loading into the table. YYYYMMDD is right format. I am trying to write server Routine but never wrote a...

thanks !
Got it

HI, I am getting follwoing error while running my PX job in DS "Lookup_192,1: Failed a keylookup for record." "Operator's runLocally() failed" Here is what I have, 1) Data_set --> Modify(to take care Null fields which is in look up)-->trn-->lookup 2) ORA -->TRN -->Lookup (same as...

thanks!!! elavenil , I got it

ArndW's way to clear status file is worderful and it will come to compiled mode once it is done.

we had same situation as you are having and we follow that route and setttled everything.

--raj

Hi, How Can I - 1) I want to know HOw Can I find all the jobs which are using Oracel Table eg. "Emp table" Meaning If i want to know what are the different job which used my table 2) In reverse, I want to know How Can I find all the table used by DataStage job Please reply me back --Raj