Hi ,
Today 1000 records updated, tomorrow 500 records updated how
to find that?
- 4 Answers
- 12606 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 transfer file from one system to another system in unix? which cmd to be use?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Can you implement SCD2 using join, transformer and funnel stage?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
How do you reject records in a transformer?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
What is the difference between orabulk and bcp stages?
How do u view log file for a particular job?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
How do you import and export the datastage jobs?
Teradata 
