Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 12837 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nish
there are plenty of options available.
just carefully study the scenario.
Source: 4 Mil records (doesn't change)
Target: 3 Million already loaded
Option1:
you just need to identify those 1Million pool them and then load to target.
This is clearly a case for Change Data Capture (CDC) stage.
use the Source As Before Table and Target as After.
Write those 1 Mil records based on change_code() (Deleted) to a file.
Move the contents of this file to target.
Option 2: This scenario also hints at updating the target with merge stage.use the DROP option to gather into a file and then update the target.
Option 3: Look Up being a performance concern should be your alternative.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
I have a few records just I want to store data in to targets cycling way how?
Whats difference betweeen operational data stage (ods) and data warehouse?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
On which Dimension Table you implemented SCD Type in your Project
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How to Remove Duplicate using SQL?
What are the various kinds of the hash file?
Explain datastage architecture?
What are transforms and what is the differenece between routines and transforms?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between server job and parallel jobs?
How do you start developing a datastage project?
What are constraints and derivations?
What are the differences between datastage and informatica?
