 Related Questions Latest Answer : In datastage sequence,there is "Exception Handler" activity.When you are calling your jobs from a Datastage Sequence you should do following :Step 1: Go to properties of master sequence and check the checkbox "Automatically handle activities ... Read Answers (2) | Asked by : Amar If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error? Read Answers (6) | Asked by : etl 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 Read Answers (1) | Asked by : Amar How can I identify the duplicate rows in a seq or comma delimited file?the case is...> the source has 4 values like, agent id, agent name, etc... our requirement is that the ID shouldn't be repeated. so how can i identify the duplicate rows , set a flag and send the rejects to the specified reject file? the source systems data is directly given to us. tha's why we are getting these duplicates.if it has a primary key set up already then it would have been very easy.thanks in advance. Read Answers (3) | Asked by : DS beginer 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? Read Answers (4) | Asked by : srinivas How do you remove duplicate records from a file and capture the rejected records in a separate file. How do you remove duplicate records from a file and capture the rejected records in a separate file. Latest Answer : lookup we can set condition option otherwise then reject records enter into target we can direct load data what ever it may be load and create ... Read Answers (1) | Asked by : Ninganagouda I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer. View Question | Asked by : pompui How can we improve the performance of a link collector in the case of handling more than 25000 records? Read Answers (1) | Asked by : devasena View Question | Asked by : cnew
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
