Interested to Buy Any Domain ? << Click Here >> for more details...
How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
- 1 Answers
- 5560 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
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 are the benefits of datastage?
what is the main differences between Lookup, Join and Merge stages?
A flatfile 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 the job?pls give the steps?pls pls
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.
How do you reject records in a transformer?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
What are the different types of lookups in datastage?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
Teradata 
