what is the advantages of other etl tool than teradata
utilities or vice versa ?(datastage/informatica)

Answers were Sorted based on User's Feedback



what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informat..

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

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informat..

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

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informat..

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

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informat..

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

Post New Answer

More Teradata Interview Questions

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,


TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,


How does hashing happens in teradata?

0 Answers  


What is partitioned primary index (ppi)?

0 Answers  


In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,






1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,


What is node? How many nodes and amps used in your previous project?

0 Answers  


What is the command in bteq to check for session settings ?

0 Answers  


How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  


I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,


What is a pseudo key? What is its use???

2 Answers   Mphasis,


What is the maximum number of dml can be coded in a multiload script?

0 Answers  


Categories