what is main difference between change capture and change
apply stages
Answer Posted / abdullah
read answer 2 first because i`m appending this answer to it so u can understand more.
*change capture views you the records that were change only, without telling you the rest of of the original records
ex: if one records was changed among 5 records then it will view it alone.
-(it will take two input, the before data set and the after data set)
*change apply should take the original data set and the change capture data set and then apply the change to the original copy as an output. as a result you have now all the records including the new and changed ones.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
describe the Steps to confiure a Qlogic switch
What is the difference between server job and parallel jobs?
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
Can you implement SCD2 using join, transformer and funnel stage?
What are the job parameters?
Explain connectivity between datastage with datasources?
Define Data Stage?
What are datastage sequences?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is usage analysis in datastage?
What are the benefits of datastage?
Where do you see different stages in the designer?
Differentiate between operational datastage (ods) and data warehouse?
What is aggtorec restructure operator?