How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
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 are the enhancements made in datastage 7.5 compare with 7.0?
What is ibm datastage?
What are the types of views in datastage director?
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 are the benefits of datastage?
How to reverse the string using unix?
How can one find bugs in job sequence?
Explain entity, attribute and relationship in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the types of containers and how to create them?
Name the different types of Lookups in Datastage?
What are the partitioning techniques available in link partitioner?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are system variables and sequencers in datastage