I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..
Answer Posted / bharath
in datastage administrator we can enable add check point on failure option we can start from 401 record....
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define Job control?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between operational data stage (ods) and data warehouse?
Can we use target hash file as a lookup ?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is a merge in datastage?
What are the various kinds of containers available in datastage?
How do you run datastage job from the command line?
What is the flow of loading data into fact & dimensional tables?
Differentiate between datastage and informatica?
What is the differentiate between data file and descriptor file?
Define Merge?
Distinguish between informatica & datastage. Which one would you choose and why?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)