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 |
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
how to cleansing data
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
How to transfer file from one system to another system in UNIX?which command to be use?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
How do you reject records in a transformer?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?