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 do you reject records in a transformer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Where do the datastage jobs get stored?
options available in sequence job to run,validate?
What is job control?
What is the command line function to import and export the ds jobs?
What is a ds designer?
What is the precedence of stage variables,derivations, and constraints?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
how to sort two columns in single job in datastage.
What are the important features of datastage?
In Datastage, how you can fix the truncated data error?
If you want to use the same piece of code in different jobs, how will you achieve it?
Explain the importance of surrogate key in data warehousing?