Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

What is the Difference between Change capture stage and
Difference Stage ? What are its significance individually ?

Question Posted / vemuri.sriharsha


What is the Difference between Change capture stage and Difference Stage ? What are its significanc..

Answer / rakesh gupta

There is not much difference between cdc stage and difference stage.Both the stage similar.

Difference between cdc stage and difference are following:-

1.In CDC stage,we should have same number of columns and same column name from both the input link.However,In difference stage we can have different number of column and Different column name.
2.The CDC stage takes two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set.However,Difference stage performs a record-by-record comparison of two input data sets, which are different versions of the same data set designated the before and after data sets. The Difference stage outputs a single data set whose records represent the difference between them.

Is This Answer Correct ?    6 Yes 10 No

Post New Answer

More Data Stage Interview Questions

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

How to remove blank spaces from data?

3 Answers  

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

where the log files or tables can store in DS?

2 Answers   IBM,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

whom do you report?

0 Answers   NTT Data,

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

What is usage analysis in datastage?

0 Answers  

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

Define oconv () and iconv () functions in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories