ETL Sample Query

[abhaysk]

Originally posted by pando
agree, piece of crap

Pando :

But it can interact with different flavours of DBs.....like Oracle, MS SQL Server, Informix, PeopleSoft, MY SQL, SYBASE, IBM DB2 & so on..........
In this regard i belive its good.....

Ya it has many a limitations.....cant implement complex logic involed unlike PL/SQL.....

Abhay.

[pando]

I work with Oracle so it´s a crap for me

An ETL tool for Oracle and cant make use of it´s direct-load function I will simply not use it

[abhaysk]

Pros n Cons will alwys be ther

[slimdave]

Originally posted by abhaysk
Pando :

But it can interact with different flavours of DBs.....like Oracle, MS SQL Server, Informix, PeopleSoft, MY SQL, SYBASE, IBM DB2 & so on..........
In this regard i belive its good.....

Ya it has many a limitations.....cant implement complex logic involed unlike PL/SQL.....

Abhay.

Oracle Hetrogenous Services do just the same multi-db connectivity.

And complex logic is another thing i forgot -- try implementing a conditional loop in Informatica. That's not even complex, it's a basic property of a programming language that is terribly difficult to implement in Informatica

[st2000]

Allright...

Let us jump back to address the main purpose of this forum..

For any of you, who is curious to see some sample code..

http://otn.oracle.com/sample_code/pr...rnalTables.pdf

Just atleast gives some ideas, for people starting on ETL...

If anyone has any more pointers, please post it..

Thanks, ST2000

[irehman]

Check out informatica.com or Abnitio.com, also Datawarehousing.com. ETL can not be defined in a paragraph, it's a whole new ball game.

[pando]

Extraction, Extracting from source
Transformation, Transform extracted source to adapt destination source
Load, Load to destination

I dunno but myself for example I find these words self explanatory, I never used any book to understand the meaning of these words