Hi ,
Today 1000 records updated, tomorrow 500 records updated how
to find that?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is apt_config in datastage?
what is executable in DataStage?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Have you used Unstructured data?
what is operator combinality in datastage?
What are the different database update actions available?
What all are the different way to run a job?
Hi Vijay here For Four CPU's how many nodes will required?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What is a ds designer?