GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  what is the difference between datastage and informatica



July 07, 2007 06:42:02 #8
 Mohan Krishnan Mannam   Member Since: Visitor    Total Comments: N/A 

what is the difference between datastage and infor...
 

Informatica and DataStage both are ETL tools, which are used for data acquisition process, Nothing but ETL the main difference between Informatica and DataStage is for Informatica the repository (container of meta data  is database-meta data is stored in database for data stage the repository is file-meta data is stored in file before going to ETL Informatica & DataStage will check the repository for meta data here accessing a file is more faster than database because file is static but data is more secure in data base than file-data may be corrupted in file hence finally we can conclude that data stage will perform faster than Informatica but when it comes to security issue Informatica is better than DataStage

     

 

Back To Question