how to design the change capture stage in(data stage
parallel jobs) type 2
Answer Posted / nidhi
1.for change capture stafe u need two input dataset one is
old one & second is the new or updated one.
2. incoming data should be sorted.
3. allow what kind of u need to check like new , delete,
change,copy.
4. if u wanna all new data should be passed to the outgoing
link then u need to specify Drop Output For insert=true.
5.there should be a change key or change key value, on the
basis of key data will be chaecked.
thanks
Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
What is active and passive stage?
What is the process of killing a job in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the use of datastage designer?
How to reverse the string using unix?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the components of datastage?
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
Define Job control?
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
Describe the architecture of datastage?
What steps should be taken to improve Datastage jobs?
Is possible to create skid in dim,fact tables?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How to clean the datastage repository?