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
What are the different types of lookups in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is the different type of jobs in datastage?
Can you explain engine tier in information server?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Explain the importance of surrogate key in data warehousing?
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
Difference between server jobs & parallel jobs?
What is the purpose of pivot stage?
How do you schedule or monitoring the job?
On which Dimension Table you implemented SCD Type in your Project
What is the importance of the exception activity in datastage?
AGGREGATOR default datatype
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Differentiate between operational datastage (ods) and data warehouse?