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
- 16137 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
What are the various reporting tools in the market?
What is partitioned primary index (ppi)?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is a clique?
Can you fastexport a field, which is primary key by putting equality on that key?
Different phases of multiload?
What are the multiload utility limitations?
What do you mean by fastexport in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the primary index in teradata?
What are teradata utilities?
What is the difference between fastload and multiload?
Explain the term 'foreign key' related to relational database management system?
How you will check the version of teradata?
If a Node is busy what are the steps you can take to avoid ?
