Interested to Buy Any Domain ? << Click Here >> for more details...
Hai..,This is Kiran M.
What is D/B Change Capture stage and Difference stage?
- 2 Answers
- 7483 Views
- I also Faced
- E-Mail Answers
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 use of surogate key in datastage
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
what are the errors,warnings in datastage
Have you have ever worked in unix environment and why it is useful in datastage?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
Explain the ChangeApply stage?
Name the different types of Lookups in Datastage?
What are the partitioning techniques available in link partitioner?
What is Horizontal transformation, vertical transformation,diagonal transformation?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
Teradata 
