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

Hi ,

Today 1000 records updated, tomorrow 500 records updated how
to find that?

Question Posted / simha

Answers were Sorted based on User's Feedback



Hi , Today 1000 records updated, tomorrow 500 records updated how to find that? ..

Answer / saikiran katari

using BATCH ID or ROW ID or VERSION ID WE CAN SOLVE THIS PROBLEM..

Is This Answer Correct ?    7 Yes 0 No

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that? ..

Answer / murali

By using CDC stage ..provide before and after datasets to CDC through CDC stage u get change code =3 then you can get updated records

Is This Answer Correct ?    3 Yes 0 No

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that? ..

Answer / varma

As a developer you cannot find it unless you have CREATE_TS column in the table. Its always a best practice to have this column which records timestamp.

DBAs can find out in several ways (Tracing etc) but its not a straight forward way

Is This Answer Correct ?    2 Yes 2 No

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that? ..

Answer / ranjit reddy a

by using scd1,scd2

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

what is hash file

2 Answers   CTS, IBM,

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

how can we do null handling in sequential files

2 Answers   Reliance,

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

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  

what is ds administrator used for?

0 Answers  

What are the stages in datastage?

0 Answers  

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

Difference between in process and inter process?

0 Answers  

Where do you see different stages in the designer?

0 Answers  

How to implement complex jobs in data stage?

0 Answers  

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories