We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage
Latest Answer : Routine : Routine is like procedure which is called to process certain operation.GoSub ADD(A,B)ADD(A,B):C=A+Breturn C ...
Latest Answer : main difference is routines are return the value , transform are cannot return the value.. ...
What is the difference between importing table definitions by Orchestrate Schema Definition or Plug-in Meta Data Definitions?
1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile?
Main difference between Datastage7.5 and 7.5.1a. how to upgrade the job written in 7.5 to run on 7.5.1a
Error while connecting to DataStage project-expiry date '-479/1/71379' is unrecognizable Requirement: I have installed datastage7.5 server/client on windows 2003 server, the installation has been done successfully, but later when I login into the projects it is giving an error.Requirement : I have installed on the Windows 2003 server datastage7.5 server/client. the installation has been done successfully. but later when I Login into the projects it is giving an error. Error Description:
How are SQL's in one transactions written in DS. I mean open a transaction , insert, update, delete, close transaction.thanks,Chandra
Latest Answer : A Filter stage is used to filter the incoming data ,for suppose u want to get the details of customer 20 if u give customer 20 as the constraint in filter it will display only the customer 20 files and u can also give a reject link,the rest of the ...
Latest Answer : Lookup stage: 1.Can only return multiple matching rows from one reference.2. Can reject rows based on constraint.3. Can set failure.4. Does not need partitioned and sorted input.
Merge stage: 1. Can reject rows if fail to find match.2. Does need partitioned ...