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 |
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is APT_DUMP_SCORE?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to sort two columns in single job in datastage.
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
What is container and then types?
Nls stands for what in datastage?
Describe stream connector?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
what is meta data? Explain? Where it is used?