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
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?
Is the value of staging variable stored temporarily or permanently?
How can one find bugs in job sequence?
Explain datastage architecture?
What is orabulk stage?
What is the roundrobin collector?
What is the difference between Datastage 7.5 and 7.0?
Is possible to create skid in dim,fact tables?
What is the importance of the exception activity in datastage?
Name the different sorting methods in datastage.
How to reverse the string using unix?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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...
Explain connectivity between datastage with datasources?
Demonstrate experience in maintaining quality process standards?