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
how to sort two columns in single job in datastage.
what is the custome stage in datastage? how can we impliment that one? plz tell me
How many types of hash files are there?
What is apt_config in datastage?
options available in sequence job to run,validate?
How do you generate sequence number in datastage?
Describe stream connector?
On which interface you will be working as a developer?
what is ds administrator used for?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is data partitioning?
Distinguish between informatica & datastage. Which one would you choose and why?
How to read multiple files using a single datastage job if files have the same metadata?
What are the difference types of stages?