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
- 16212 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 scenarios in which full table scans occurs?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the string manipulation operators and functions associated with teradata?
List out some of the primary characteristics of teradata.
Difference between multiload and tpump?
What are different table types used in teradata?
Explain amp in teradata?
When tpump is used instead of multiload?
Highlight a few of the advantages that ETL tools have over Teradata.
Highlight the points of differences between the database and user in Teradata.
How does hashing happens in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What do you mean by teradata intellicloud?
What happens when a node suffers a downfall?
What are the components used in smp and massively parallel processing (mpp) machines?
