how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
521Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
347
What are the types of containers in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Whats difference betweeen operational data stage (ods) and data warehouse?
How do you run datastage job from the command line?
how to write server Routine coding?
What are system variables and sequencers in datastage
What are sequencers?
What is the use of datastage designer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How a server job can be converted to a parallel job?
What is the difference between Datastage 7.5 and 7.0?
What is usage analysis in datastage?
What is a merge?
What is the purpose of pivot stage?
What is the difference between validated and compiled in the datastage?
