Interested to Buy Any Domain ? << Click Here >> for more details...
Hi ,
Today 1000 records updated, tomorrow 500 records updated how
to find that?
- 4 Answers
- 13484 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How to use Environment variable's in datastage?(use of process)
Difference between in process and inter process?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
how many rows sorted in sort stage by default in server jobs
how to add a new records into source?
job locking methods? How can we unlock the job?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
Pls tell me what is troubleshooting in datastage view?
what is sparse lookup?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
Differentiate between odbc and drs stage?
Teradata 
