open source : Pig, Hive, Cascading ...
other : Talend ...
Is that the answer you are expecting or are you looking for something more
specific?
Regards
Bertrand
On Tue, Oct 8, 2013 at 5:47 PM, Jitendra Yadav
<jeetuyadav200890@gmail.com>wrote:
> Hi All,
>
> We are planning to consolidate our 3 existing warehouse databases to
> Hadoop cluster, In our testing phase we have designed the target
> environment and transferred the data from source to target (not in
> sync but almost completed ). These legacy systems were using
> traditional ETL/replication mechanism like Golden gate, Loaders,
> PL/SQL language etc., FYI we are using 80% PL/SQL code and SQL server
> packages in current environment, however we have re-writing some of
> ETL jobs through java and python MR but looking for some more and easy
> alternatives.
>
> What is best approach we should follow to complete this process? while
> suggesting please take effort and timing in consideration( if
> possible).
>
> Please guide.
>
> Regards
> Jitendra
>
|