Browse by Tags

Do Not Forget to add Business and Flow control to your ETL
04 June 08 09:56 AM | Ronen Chenn | with no comments

Suppose your ETL worked fine at the night window but the users calls you at 08:30 and tell you that the numbers does not figure. Well, there are several reasons for this problems: the data came badly from the OPERATIONAL SYSTEM, something happened to you ETL, or the sales for example where real bad. In order to eliminate the first two you must build control process that decides whether the data are good enough for the users. There are two controls you should have: business control and flow control...

תגים:SSIS Best Practice

Running SSIS on 64 BIT ITANIUM and read from ORACLE
13 April 08 09:20 PM | Ronen Chenn | 1 comment(s)

Hi ALL, Those of you who has no other choice but running SSIS on 64 BIT ITANIUM which is not so nice..., should try this settings: 1. Install ORACLE (64-bit) 10.2.0.3 for Windows x64 . (latest patch) 2. Define at the environment variable the path to ORACLE HOME . 3. If you had scripts written on 32BIT , you have to compile them on 64 bit, a typical workaround is to open them and define recompile=true on the target machine. 4. If the source table has a Numeric or Currency data type, try to transform...

תגים:SSIS 64BIT ITANIUM ORACLE, SSIS Best Practice