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


Please Help Members By Posting Answers For Below Questions

How many types of views are there in a datastage director?

832


How many Key we can define in remove duplicate stage?

818


What are the types of views in datastage director?

1243


Whats difference betweeen operational data stage (ods) and data warehouse?

667


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027






Have you have ever worked in unix environment and why it is useful in datastage?

645


What are the different layers in the information server architecture?

641


Define meta stage?

778


What could be a data source system?

573


What are the types of hashed files in data stage

640


What are orabulk and bcp stages?

645


what are the errors,warnings in datastage

2145


What is "fatal error/rdbms code 3996" error?

663


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263


Name the command line functions to import and export the DS jobs?

705