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)
920Source 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
781
What are the types of hashed files in data stage
What are the types of containers and how to create them?
How rejected rows are managed in datastage?
What are the features of datastage flow designer?
What is staging variable?
What are the different options associated with dsjob command?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How a source file is populated?
What are data elements?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Difference between sequential file and data set?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Which commands are used to import and export the datastage jobs?
What is the importance of the exception activity in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara