Hi ,
Today 1000 records updated, tomorrow 500 records updated how
to find that?
- 4 Answers
- 12888 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 |
With out using Funnel Stage, how to populate the data from different sources to single target
how to identifie,is it innerjoin,leftouter join in lookup?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
How to RD using transformer?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is Horizontal transformation, vertical transformation,diagonal transformation?
Define oconv () and iconv () functions in datastage?
Give example for FACTLESS FACT TABLE in real-time scenario.
What r the existing server jobs in parallalism?
What is the project in datastage?
Unix command to view the data in a dataset
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
Teradata 
