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 are the various kinds of containers available in datastage?
EXPLAIN SCD
What are stage variables and constants?
what is the difference between == and eq in UNIX shell scripting?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what is use of SDR function?
Define repository tables in datastage?
Can you explain repository tables in datastage?
Name the different types of Lookups in Datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are routines in datastage?
What is ibm datastage?
How and where you used hash file?
What is the use of datastage director?
how to sort two columns in single job in datastage.