Hai..,This is Kiran M.
What is D/B Change Capture stage and Difference stage?
Answers were Sorted based on User's Feedback
Answer / chandu
change capture stage produces the differences in two sets
of data that is before set and after set by comparing it
thru row wise in two sets, while in case of difference it
produces by diff code based on column wise this my answer
can any one justify it
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajeshchunduri
change capture is processing stage. it supports 2 i/p links
called before and after and 1 o/p link.this stage is used
to represent the changes made to the before source to obtain
the after source .
difference stage supports 2 i/p's and 1 o/p .this vl give
the information about changes made before source to obtain
after source.
| Is This Answer Correct ? | 0 Yes | 2 No |
What modeling tool do you use?
what is meta data? Explain? Where it is used?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
What is a quality stage in datastage tool?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Differentiate between operational datastage (ods) and data warehouse?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how do u capture duplicates through sort & transformer
What is the difference b/w Hash file and Lookup Fileset stages?
What are the different type of jobs in datastage?
Differentiate between data file and descriptor file?