what is the advantages of other etl tool than teradata
utilities or vice versa ?(datastage/informatica)
Answer Posted / vinay sir(datawarehousing tech
It is a good question Guys....
TD Utilities run faster than other ETL tools
incase 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.Reusability 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....
Like these there are many additional advantages are there.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Where is teradata rdbms used?
What is meant by a node?
What is upsert statement in teradata?
Differentiate database data and data warehouse data?
What is spool space? Why do you get spool space errors?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is real time and near real time data warehousing?
What is the difference between teradata and oracle?
What are the frequently used data types in teradata?
Can you connect multiload from ab initio?
Why does varchar occupy 2 extra bytes?
how many modules are there in telecome domain?how to explain the architecture?
List out teradata data types?
What is node? How many nodes and amps used in your previous project?
Highlight the points of differences between the database and user in Teradata.