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 is the difference between operational data stage (ods) and data warehouse?
How do you remove duplicate values in datastage?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
types of errors in datastage?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
count number of deptno in a emp table?
What are constraints and derivations?
how to capture rejected data by using join stage not for lookup stage. please let me know
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
What is the importance of the exception activity in datastage?
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?