If you’re like me, you work in many many environments. I’ve been a long-time user of PowerCenter and Informatica’s products continue to shine for me. I can develop stuff in Informatica very very fast. I’ve recently (over the last month or two) gotten really good at building OWB mappings, and while I kind of like the 100% push-down end-result (Oracle Packages are produced), I am weary of working in the designer. There are so many design time quirks and bugs that it’s hard to “get motivated” to create inside OWB Designer. I’ve recently heard that Oracle plans to “replace” OWB/OMB with something new, something they just acquired… we’ll see what happens. This entry is VERY SHORT, and compares designining mappings in OWB versus Informatica PowerCenter.
I use design patterns to actually design the same functional mappings in both environments. Highly restartable, fault-tolerant, parallel enabled, performance driven, etc… To that end I spent some time in OWB designer building the mappings that I have built in PowerCenter in the past.
Here’s the Sunopsis (sorry for the pun ie: synopsis) of it all…
45 minutes to design, debug, and deploy a mapping with de-dup, expression (datatype re-cast), lookup, filter, constant, sequence generator, and target.
10 minutes for the same thing, that’s a HUGE savings, but wait theres more!!
An additional 15 to 25 minutes was spent adding and moving fields around, realizing that I had to add a data type cast expression myself, and that the deisgn tool wouldn’t do it for me, which ended up in 1 corrupted mapping, another edition of the mapping (re-written by hand + another 20 minutes) wouldn’t synchronize the lookup properly, so yet another re-write by hand (this time 20 minutes on top of it all)… and Finally I had a mapping that Validated.
Once it validated, it wouldn’t deploy properly – when I deployed I got Oracle “parenthesis” and other obtuse errors – when I examined the deployed code, there was nothing wrong with it, but I was pointed to “conditions” in the lookup, and the filter. I had to go back to the lookup & filter, and manually validate EACH of these by pressing the VALIDATE function. Once validated, it deployed – no errors.
So, 1.5 hours later I had a working mapping. With Informatica, added a session and a workflow, and a total time of 15 minutes, and it was running.
Take your pick…. I’d say design time in OWB is SLOW SLOW SLOW…
By the way – what have you found? Love to hear your numbers and feedback, add a comment below…
What about the FUN side of the Island? (sorry, quip from the movie: Madagascar)…
The FUN side of the island is… tada! Code Generation…. I can now generate ETL code for importing to OWB, AND importing to Informatica. Total Result? I can import FLAWLESS 100% ready-to-run code for both tools in record time.
In other words, I’m not STUCK on the designer in either tool anymore… I can generate code from a cross-reference, a source, and a target model for ALL Hubs, ALL Links, and ALL Satellites – over 150 mappings in less than 20 seconds, and I can choose: run them in OWB OR run them in Informatica (makes no difference to me).
You can contact me for more information on this, I’m thinking of releasing this feature set as SaaS – let me know if you are interested.