DSXchange

Hi Roy, just by the way what platform are you on? I've used IQ a bit but not with DS, only with INFA. 'Regular Sybase for repository.' Well, no, it uses Sybase ASA which is a really small footprint database. This is what you connect to using ODBC. Actually, how it works is the 'catalog' is stored in...

Bobby, let me guess, the client has written their ETL in PL/SQL + Oracle views etc??? If this is the case I've put my comment on this on my FAQ page. http://www.peternolan.com/faqs.htm#A004 My advice to customers who have done this and want to 'upgrade' what they have done with DS? 1. Take out a bla...

Hi nkln@you, please be aware that the performance of this routine is terrible and should be avoided if your volumes are above nominal. I think someone else posted a routine.....we had one developed and I believe the client owns it so I wouldn't post it here. How to use the routine KeyMgtGetNextValue...

Hi Josyula, I am expert level on both products. If you are considering use DS instead of INFA or as well as INFA and you have specific questions you would like answered please feel free to email me at peter@peternolan.com. There are some very specific and major differences in the way jobs are writte...

We currently have Redbrick 6.2 and datastage 7.2 Server in the production. We are likely to migrate our database from Redbrick to DB2 and I am doing some analysis of what are the impact and changes need to happen in the datastage jobs. Well I know that we used some special functions and syntax need...

Hi Ogmios, can't use CDC. Oracle Apps does not have primary keys defined and CDC requires primary keys....we are ensuring we get all data by having a timestamp range extracted and recommending a quiesce of Oracle prior to starting incremental extracts. We have been told Oracle apps cannot even use t...

Hi All, that INFA actually gain 'points' in the sales cycle by having an 'open' repository on a relational database is simply an indication of the ignorance of the evaluators giving it points. I've used INFA extensively, and you can't read/understand and produce reasonable reports/analysis out of th...

Hi B/All, we have now got it working for OCI but we cannot get it working for ODBC and we have written all our ETL using ODBC....we've got the problem in with support, but if anyone has got this working on ODBC I'd be very interested. We have 22 significant digits working working with wire driver an...

Hi All, given the underwhelming response to this question....the next question kind of struck me.....has anyone else out there actually done an Oracle 11 apps -> DW project in DataStage??? (Please, someone say yes...) Hi All, I could not find a forum for PACKs so I tried here. We recommended to the ...

Hi Arun_im4u, check this out.. http://www.dsxchange.com/viewtopic.php?t=88832&highlight= Hi, Is it possible to convert a sequential file into xml format inside datastage. I have this problem where I get a file in xml format i decrypt it in UNIX and then convert it into sequential file and use fo...

Hi dwscblr, Ascential have a product for this, it's called MetaStage. It migrates all DS data into a relational database as well as a lot of other stuff as well. If you are brilliant, like Tom Nell you might even be able to understand the data model of MetaStage and get stuff out of it. Or you can j...

Hi Ray, the 22 comes from the maximum size of a 38 digit precision numeric stored as decimal......38/2+3 apparently. I really don't get it myself but its on one of the oracle newsgroups... The message I get is as follows: oe_price_adjustments_oci2..tgt_oe_price_adjustments.IDENT1: At row 1420, link ...

Hi Ray, the 22 seems to be inside the Oracle database...DataStage is sending the ful 38 digits to Oracle through the ODBC interface and the message is an oracle message saying num1 has been truncated to num2 where num1 and num2 are the full 38 digits and the truncated 22 digits.....I am almost certa...

Hi Ray, a very good question....I'll have to ask tomorrow...I've done the cast and used varchar2(50) and that works fine, brings back whatever is in the oracle table......we are unable to load it into our oracle instance because it is being truncated to 22 significant digits...and when I look at all...

Hi All, yes, me again....on Oracle 'NUMBER' fields in Oracle Applications. We have some fields in OA that have more than 15 significant digits. The client wants ALL significant digits to come across to the DW. But try as we might, using ORA OCI or ODBC every time we try to read one of these fields w...