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)
602Source 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
429
Have you used Unstructured data?
What are the types of hashed files in data stage
What is the difference between operational data stage (ods) and data warehouse?
What are datastage sequences?
What are the areas of application?
Why do we use link partitioner and link collector in datastage?
What is the differentiate between data file and descriptor file?
What are routines in datastage? Enlist various types of routines.
options available in sequence job to run,validate?
What is ibm datastage flow designer?
How a source file is populated?
How many areas for files does datastage have?
Explain entity, attribute and relationship in datastage?
Terminate Activity
Define oconv () and iconv () functions in datastage?
