what is main difference between change capture and change
apply stages
Answer Posted / shady
change capture stage catch holds of changesfrom two
different datasets and generates a new column called change
code....change code has values
0-copy
1-insert
2-delete
3-edit/update
where as change apply stage applies these changes back to
those data sets based on the chanecode column
Is This Answer Correct ? | 40 Yes | 2 No |
Post New Answer View All Answers
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Define Data Stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How rejected rows are managed in datastage?
What are orabulk and bcp stages?
What are the various kinds of containers available in datastage?
Define Merge?
Differentiate between Join, Merge and Lookup stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What a datastage macro?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Can you explain tagbatch restructure operator?
What are the difference types of stages?
Difference between server jobs & parallel jobs?