Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantages of other etl tool than teradata
utilities or vice versa ?(datastage/informatica)
- 4 Answers
- 16042 Views
- I also Faced
- E-Mail Answers
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
why use references rather than pointers in the public api, particularly for arguments which are modified?
Why managing the data is important?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the steps involved after the disk manager passes the request?
What's the difference between timestamp (0) and timestamp (6)?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How does hashing happens in teradata?
How is MLOAD Client System restarted after execution?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Describe the between keyword in teradata?
What is meant by a Clique?
Did you write stored procedures in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
In Teradata, what is the significance of UPSERT command?
