Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)




553
views
asked mar September 20, 2014 06:37 AM  

What is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)


           

1 Answers



 
answered By vishnoiprem   0  
TD Utilities run faster than other ETL tools
in case of File to Table(Import) or Table to File (Export) Operations.Inmod and Outmod also help us to do better
prograaming while Importing and Exporting.

Major advantages of Other ETL tools than TD Utilities:
1.Heterogenous Sources and Destinations we can Operate.
(Oracle,Sqlserver,Excel,Flat Files etc....)
2.As they are providing full GUI support,degugging
is so easier.
3.Re usability of components(Informatica:mapplets,worklets etc...) avaiable in ETL tools so if we change in main
location automatically other applications(mappings) which are using these components can update instantly.
4.Pivoting(Normalization),Unpivot(Denormalization) we can implement very easily in ETL tools.
5.Caching is one more advantage when we work with a source (Heterogenous) which is not changing frequently.Some times
cache can be shared across applications etc.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert