Out of 4 mill records only 3 mill records are loaded to
target
and then job aborted. How to load only those 1 mill(not
loaded records) for next run.
This job is not sequential job, it is stand alone parallel
job.What are the possibilities available in datastage8.1?
Answer Posted / venkatesh
first load the data using with surrogate stage
after that use filter stage and take that key of
surrogateand in lookup maintain the Drop option
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
How complex jobs are implemented in datstage to improve performance?
What are the processing stages?
What is ds designer?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How to find value from a column in a dataset?
How one source columns or rows to be loaded in to two different tables?
How can you write parallel routines in datastage PX?
How do you schedule or monitoring the job?
Explain entity, attribute and relationship in datastage?
How a routine is called in datastage job?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
On which Dimension Table you implemented SCD Type in your Project
Can you highlight the main features of ibm infosphere information server?
options available in sequence job to run,validate?
Explain the situation where you have applied SCD in your project?