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
- 16355 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arun
Thanks Vinay sir for your answer...
Sir,small request, can you provide me more interview
questions what you are asking in IBM interview.Now I am in
Bangalore, I can't come to Hyderabad.Pleas sir.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yuvaevergreen
In addition to the vinay's answer, when open source tool
like Pentaho is used, real time data can be injected in to
the job which would not be possible in load utilities.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / johnny
Don't go to Teradata course.
Waste of time.
Less jobs and more competition.
Even am also searching for job.
Vinay Sir explanation is good but jobs are less
| Is This Answer Correct ? | 3 Yes | 2 No |
Explain the term 'foreign key' related to relational database management system?
What is meant by a Highest Cost Plan?
why should we go Teradata over Oracle,what is the main differences?
How to find duplicates in a table?
What are the different methods ot loading a dimension table? A fact table etc?
What is Difference b/w PI & PPI?how to implement PPI?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the scenarios in which full table scans occurs?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How to eliminate product joins in a teradata sql query?
What is teradata and why it is used?
what is the structure of UV table in MLOAD?
Teradata 
