How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
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 |
What is the difference between the local container and shared container?
How many types of views are there in a datastage director?
What is the difference between Link collector and Funnel Stages?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
which r the connectors used in san?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
How can remove duplicates in a file using UNIX?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
What are the types of hashed files in data stage
What is the differentiate between data file and descriptor file?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What is difference between server jobs & parallel jobs?