How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
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 |
State the difference between an operational datastage and a data warehouse?
Could anyone give brief explanation bout datastage admin
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
Enlist various types of routines in datastage.
What are the types of containers in datastage?
DataStage Scenario based Interview Questions
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
what is the difference between datasatge and datastage TX?
how to handle null values in sequential file?
How to convert alpha Numeric values to alpha using functions?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
What are the important features of datastage?