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
- 13407 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 |
plz tell me some dimentional and fact table names in banking project?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
which r the connectors used in san?
Whats difference betweeen operational data stage (ods) and data warehouse?
What r the existing server jobs in parallalism?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
What is the default padding character?
How we can convert rows to columns in datastage?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
If you want to use the same piece of code in different jobs, how will you achieve it?
Teradata 
