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 |
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is the diff b/w switch and filter stage in datastage
What is the difference between SQl Loader and OCI in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
How do u convert the columns to rows in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
how to add a new records into source?