Interested to Buy Any Domain ? << Click Here >> for more details...
How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
- 1 Answers
- 5697 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of pivot stage and types of containers in datastage
What is process model?
What is quality stage?
What are some different alternative commands associated with "dsjob"?
Have you used Unstructured data?
sed,awk,head
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How to read multiple files using a single datastage job if files have the same metadata?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is use Array size in datastage
what is the custome stage in datastage? how can we impliment that one? plz tell me
How and where you used hash file?
What are datastage sequences?
How will you move hashed file from one location to another location?
Differentiate between operational datastage (ods) and data warehouse?
