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
- 13119 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
What are the difference types of stages?
How do u convert the columns to rows in datastage?
options available in sequence job to run,validate?
Demonstrate experience in maintaining quality process standards?
How the ipc stage work?
Can you explain repository tables in datastage?
Enlist various types of routines in datastage.
Differentiate between Join, Merge and Lookup stage?
Differentiate between data file and descriptor file?
How complex jobs are implemented in datstage to improve performance?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Describe the main features of datastage?
which r the connectors used in san?
How can one find bugs in job sequence?
What could be a data source system?
