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 |
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
how can find maximum salary by using Remove duplicate stage?
What is a merge?
Difference between sequential file and data set?
What are the difference types of stages?
What is the purpose of interprocessor stage in server jobs?
job locking methods? How can we unlock the job?
where the log files or tables can store in DS?
when we will use connected Lookup & Unconnected Lookup
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain briefly scd type2 in datastage7.5x2(parallel)