DSXchange

Excellent points!

Thanks for sharing.

Thanks chulett! I do understand how ODI actually works. Having it writing PL/SQL only works with Oracle DB, other DBs have different scripting which ODI support accordingly. Plus, I think this is a good feature since it can have more control on transformation in some cases, without using the paralle...

Hi folks, I'm currently doing a research to understand the major differences between: IBM Balanced Optimization and Oracle Data Integrator approach. "Balanced Optimization approach is comparable to ODI ELT architecture." How true is that statement? What are the limitations of DS approach c...

So if you have records which are something like this: ID NAME IDS --- ------- ------ 1 Issam 649874 54898 3128A 848E 2 Issam 3128A 3 Issam 649874 54898 3128A 848E 4 Issam 251989898F 3128A 848E 5 Issam 987785 6 Issam null 7 NABIL 987785 8 NABIL 98778587 1, 2, 3, 4 ARE duplicates (since they are have ...

Well, since no one tried to comment on this, I think I'll go with my logic :) Steps: 1. Prepare test data, if you have millions, it would be good idea to generate something around 25,000 or more. The more means slower testing. 2. You need to do Frequency job for this sample data. 3. You need to crea...

Hi, I finally found the solution. This line was my main clue: "Could not get mapping for one or more datatypes. Cannot create table:SPEC_1_FREQ_PROPS_DATA" I change ODBC driver and used "IBM Oracle Wire Protocol" instead of "IBM Oracle". The update worked like a charm. ...

Hello guys, This is not an issue related post, but more to suggestions on what you think the best approach is. We have a table about 60+M records, and the client needs to have some statistics about duplicate in this table, and later on remove. There are four rules to find duplicates on this table: 1...

Hi, I am have some difficulties in the Match Designer. When I fill up the Test Environment needed values, and click on Update I receive "Match Designer configuration update process failed". Full Log: ##I IIS-DSEE-TFCN-00001 11:19:50(000) <main_program> IBM InfoSphere DataStage Enterprise E...

Major, No.

Minor, yes.

Workarounds, there is.

In the end it's all about what you use. But I recommend using it (upgrading if you are an 8.1 user).

It's always fun to fix issues

Cheers.

Another solution: Use Teradata Transporter 12 libraries, that is, by pointing to 12 folder of Transporter. ONLY transporter. This workaround has been accepted by IBM, since they are still working this issue. However, they state that 13.1 Client should be fine with 13.1 Server. Certified. This, I'm g...

If anyone is facing the folloing issue main_program: Fatal Error: Duplicate name registration for: changeapply, APT_ChangeApplyOperator. main_program: orchgeneral: Could not load "orchgeneral": Unknown error (529697949) main_program: conductor uname: -s=Windows_NT; -r=2; -v=5; -n=AS207-HO-...

Hi, If anyone faced this issue: RDBMS code 5510: Invalid session mode for procedure execution Here is the solution: Although the Teradata API stage was not designed to invoke Teradata macros, stored procedures, and user-defined functions, it is possible to invoke such objects with the "User-def...

As expected.. Logs, try to run this manually.. Blah blah.. Had to find the hard way, happy it got resolved. Solution: 1. Rename (to anything, for backup purposes) telapi.dll, telapi.lib and msvcp71.dll in the bin directory of the Teradata Parallel Transport\bin (in the Teradata Client Installation) ...

*sigh* This makes me sad craig, and makes my day tomorrow very predictable! Not that not only luck you need to get some real help from IBM, but also LOTS of time.. They'll start asking for logs, then "Oh, no we need also to make sure of that .. can you please send us..".. Then someone come...

Great info from all of you guys.

But, any new updates to the stages? Anything that significantly solves previous issues and make developer's life easier?

Please share, a lot would like to know (including me).