how can or from where we can get reference data in scd type2
implementation?
Answers were Sorted based on User's Feedback
Answer / d anil babu
in change capture before data.or intial load data take refence
for delta load.
| Is This Answer Correct ? | 0 Yes | 2 No |
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
How we can convert rows to columns in datastage?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
How do you remove duplicate values in datastage?
How to perform incremental load in datastage?
what is the unix script to run the job? Please mention commands which we use often?
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?
in aggregator , how can i get the sum in readable format
Can you highlight the main features of ibm infosphere information server?
how can we create rank using datastage?what is the meaning of rank?
what is hash file