How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
- 1 Answers
- 5848 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer / ravi
Take PK of records inserted in 1st extraction from Target Database table. Write a query to exclude these records from client DB in 2nd extraction.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
how to sort two columns in single job in datastage.
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
source file is having 5 records while moving into target it want to be 10 records
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
What is difference between 8.1 , 8.5 and 9.1 ?
how to transfer file from one system to another system in unix? which cmd to be use?
What is difference between server jobs & parallel jobs?
Explain usage analysis in datastage?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
What is a merge in datastage?
What are orabulk and bcp stages?
Teradata 
