-
ETL is that which you develop custom systems by hand to..
-backup the truck and copy legacy systems data ( 20 different systems )
-marry the data together from different legacy systems ( compute farm )
-Compress the data by summarizing
-Do some transformations
-Load into Oracle using sql*loader Direct path you may get 1/4 billion rows loaded per hour
-transform the data some more using pl/sql and perl or java
-compress the data again
-roll fact tables up by dropping columns
-complete star schema
-optimize your partitioned world and make fast
Be told by snobby and stupid large companies you cannot work in their ETL department because you lack direct experience with...
Ab Initio
Informatica
etc.
GUIs that attempt to automate what you can do by manually and probably do better.
-
Originally posted by DaPi
He's probably not lazy, just too busy recompiling his UNIX kernel . . . .
Or waiting for his Windoz server to come back up (again)
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Originally posted by BJE_DBA
Be told by snobby and stupid large companies you cannot work in their ETL department because you lack direct experience with...
Ab Initio
Informatica
etc.
GUIs that attempt to automate what you can do by manually and probably do better.
At least you're not bitter about it.
-
-
I use Informatica - I should say that I'm forced to use Informatica -- and it pretty much sucks. There's so many things i hate about it i could go on forever.
-
Originally posted by irehman
Jeff, what does STFW stand for?
Schweizerische Technische Fachschule Winterthur
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
The golden rule of working in IT - it takes experience to get experience. The problem, of course, is how do you get experience in the first place?
Siebel and SPAM, oops, I mean SAP, are classic examples of this. Sure, you can go to Siebel University and get certified, but how do you get on an implementation team without having been on one before, because virtually ALL advertised Siebel jobs require previous/prior implementation experience.
-
Originally posted by DaPi
Schweizerische Technische Fachschule Winterthur
Evidently you have been abroad for too long.
Last edited by slimdave; 05-08-2003 at 12:33 PM.
-
Originally posted by slimdave
I use Informatica - I should say that I'm forced to use Informatica -- and it pretty much sucks. There's so many things i hate about it i could go on forever.
LOL!
I guess its harder to tolerate I mean learn than I give it credit
Hang in there companies love to see that experience. Missed 75 an hour chicago gig in Feb when they changed their minds and decided we need 'an informatica person'.
I did eventually get an offer from them to be employee but I took the gig here at 9000 feet in Golden colorado, elk outside the windows, dumbell weights in the next room....too bad they just canned 30% of the people and handed out 10% haircuts.
At least I am here and happy to be working with 9i,rman and data guard.
-
Originally posted by stecal
The golden rule of working in IT - it takes experience to get experience. The problem, of course, is how do you get experience in the first place?
Siebel and SPAM, oops, I mean SAP, are classic examples of this. Sure, you can go to Siebel University and get certified, but how do you get on an implementation team without having been on one before, because virtually ALL advertised Siebel jobs require previous/prior implementation experience.
I hear you. Never was out of work in my life more than 1 week, hopped from startup to startup until last xmas - CLANK!
Jan,Feb,March was an interesting time ( please get the war over with ). I interviewed all over the nation because Colorado was so dead.
Its quite a challenging game now, you have to get noticed with buzzwords out of the stack of 500 resumes. I could go on and on, 3 tiers of interviewing tech-out call, fly-out, high-level commit check, fly-out again.
The only thing they dont ask for is this : 'Must have authored 2 successful books on SAP implementation etc'
Some of these companies are just getting free consulting too.
Well we have 4 qtrs of money here now that we axed everybody. Perhaps I wont be interviewing for another year.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|