DSXchange

Hi Ray , Thanks for your reply .I am not getting that error when i am using
the either DRS stage or oracle enterprise stage with UPSERT mode .

Can anybody explain which is better oracle stage with upsert mode or

DRS stage regarding the performance wise ?

Previously I mentioned its a server job by mistake ...Actually its a parallel job ..

Hi Everybody , I am getting following error .....I am loading a database table through datastage ....structure of my job is as below seq -->> transformer ---> oracle database ....When my sequential file is of 0 KB its giving following error SQL*Loader-500: Unable to open file (\\.\pipe\ora.6440.7880...

Hi , I am having data as below ..... abcd123457020080301470789 field delimiter is none .fixed width file . actual metadata is as follows : 1st field 1-4 ---- abcd --- char 2nd field 5-11 ---- 1234570 -- number 3rd field 12-19 ---- 20080301 --- date 4th field 20-22 ----- 470 -- decimal (3,1) actual v...

Hi Everybody , I resolved the error .Previously , I gave length of the coloumn more than source filed in the table definition .I changed it and it worked well.Once again I am thankful to all for helping me out in this errror Hi , Thank you all for your replies . I have seen the log file and i am get...

Hi , Thank you all for your replies . I have seen the log file and i am getting the following error . Record 1: Rejected - Error on table table_name, column col_name. ORA-01438: value larger than specified precision allows for this column Record 2: Rejected - Error on table table_name, column col_na...

Hi all , Thank you all for resolving number of issues till now . Right Now , I got another problem while loading a oracle table using datastage. write method :load My job structure is like this seq --->> transformer --->> oracle table I am getting below error Oracle_Enterprise_4,0: The system(sqlldr...

Hi ,
I am facing a new problem in DataStage Director . I am connecting to the remote client DataStage Server . When I am viewing any Log indetail then its abruptly closing .I am unable to comprehend the problem . Could anybody tell me the reason and solution for that ??

Thanks

Hi , I have a requirement where I need to count number of lines in a flat file and store it in a variable ( say line_count ) .In the flat file , a trailer record will b present .In that Record , One field gives the count .If that count is equal to the line_count then the file is valid . I can get va...

Hi , I am using complex Flat file for reading multiple records types within a same file . The file is as follows GHIJKLABCD20070918ZX MNOPQREFGHI20070917JAHALHALJJKAHKHAKHA ------------------------------ Inabove file , the fields are as follows 1 2 3 4 GHIJKL ABCD 20070918 ZX ----- ( FIRST LINE WITH...

Hi , I am using complex Flat file for reading multiple records types within a same file . The file is as follows GHIJKLABCD20070918ZX MNOPQREFGHI20070917JAHALHALJJKAHKHAKHA ------------------------------ Inabove file , the fields are as follows 1 2 3 4 GHIJKL ABCD 20070918 ZX ----- ( FIRST LINE WITH...