Hi ,

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the precedence of stage variables,derivations, and constraints?

682


Is it possible to query a hash file?

1653


Different ways a project can be moved to production ?...example ….export-import and Version control.

2056


What is oci?

960


What are the partitioning techniques available in link partitioner?

1892






what is the use of skid in reporting?

2030


what is ds administrator used for?

830


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1913


If you want to use a same piece of code in different jobs, how will you achieve this?

914


Demonstrate experience in maintaining quality process standards?

2046


What are datastage sequences?

777


How can we improve performance of data stage jobs?

696


Whats difference betweeen operational data stage (ods) and data warehouse?

754


what is the use of surogate key in datastage

1936


Can you highlight the main features of ibm infosphere information server?

745