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

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1371


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

869


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

790


how to add a new records into source?

1724


How to read multiple files using a single datastage job if files have the same metadata?

971


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1974


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

1101


why do u need the IOS upgradation in a FC switch

2041


Notification Activity

1152


How to RD using transformer?

1090


Explain ibm infosphere information server and highlight its main features?

827


What is the purpose of pivot stage?

834


What are routines in datastage? Enlist various types of routines.

850


how do u catch bad rows from OCI stage? And what CLI stands for?

2526


How to find value from a column in a dataset?

1937